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.
Yet easier, perfect!
As variant
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
FilteredRows = Table.SelectRows(Source, each (Record.FieldValues(_){0} <> "Count:"))
in
FilteredRows