Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter a column in Power Query by position?

Hi everyone, I have a simple table like: Date Day Month Year         To filter Day, I could use = Table.SelectRows(Source, each ([Day] = "Monday")) for example. But I wonder if ther...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Anonymous ,
    you are on the right track with that approach. Just change it to:

    Table.SelectRows(Source, each (Record.Field(_, Table.ColumnNames(Source){2}) = "Monday")) 

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi Anonymous ,
you are on the right track with that approach. Just change it to:

Table.SelectRows(Source, each (Record.Field(_, Table.ColumnNames(Source){2}) = "Monday"))