Forum Discussion
Solved
Power Query: select first column for function Table.SelectRows
Dear coleagues, I get a table like this ID Name City 1 A Prague 2 B Stuttgart 3 C Cardiff COUNT: 3 I want to filter out the row COUNT in the first column of the table...
Zdenek_Moravec See attached workbook. It contains two tables based on your example where the row with "Count:" in whichever the first column is called in a table, is filtered out.
Zdenek_Moravec See attached workbook. It contains two tables based on your example where the row with "Count:" in whichever the first column is called in a table, is filtered out.
- Hello Riny_van_Eekelen,
Record.Field (_, Columnname) was the magic keyword. Then the shrinked step is
= Table.SelectRows(Source, each (Record.Field (_, List.First(Table.ColumnNames(Source))) <> "COUNT:"))
works prefect, thank You!
Zdenek
