Show all rows until first field name equals Deletions

[rki1966]

I have two columns: Index and Comments

I want to show the data until the first [Comments] = "DELETIONS"

I used this custom Column ([CommMatch]) to determine if Comments = 'DELETIONS"

= if [Comments] = "DELETIONS" then [Index] else "N")

I thought I could create a custom column (or filter) where Index is less than [CommMatch]. I can not figure out how to determine if each row index is less than the first index with a number.

 

[rki1966]

I should have indicated that I am using Power Query. Please let me know if you need more information.

Additional Information

If "Comments" in row 11 = "DELETIONS" then the query would only return the first 10 rows

 

[theBardd]

Try this

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Pos = Table.PositionOf(Source,Table.First(Table.FindText(Source, "DELETIONS"))),
    Final = Table.FirstN(Source, Pos)
in
    Final

 

[rki1966]

This is perfect, thanks