Forum Discussion

Zdenek_Moravec's avatar
Zdenek_Moravec
Brass Contributor
Aug 10, 2021
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...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 10, 2021

    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.

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Aug 10, 2021

Zdenek_Moravec 

How about simply this?

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    FirstColumn = Table.ColumnNames ( Source ){0},    
    FilteredRows = Table.SelectRows(Source, each (Record.Field (_, FirstColumn) <> "Count:"))
in
    FilteredRows
Zdenek_Moravec's avatar
Zdenek_Moravec
Brass Contributor
Aug 10, 2021
Yet easier, perfect!
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 10, 2021

    Zdenek_Moravec 

    As variant

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    FilteredRows = Table.SelectRows(Source, each (Record.FieldValues(_){0} <> "Count:"))
in
    FilteredRows

Resources