Forum Discussion

Petri's avatar
Petri
Frequent Visitor
3 years ago
Solved

Using a parameter to refer to a column in Power Query

I try to use a parameter to select a (date) column and then filter the latest value in that column. The name of the column varies in source files but is always the first column, so I tried:   Firs...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    You can use this syntax in your Filtered Rows step.

     

    = let firstcolumn = Table.ColumnNames(Source){0},
    latestdate = List.Max(Table.Column(Source, firstcolumn))
    in
    Table.SelectRows(Source, each Record.Field(_, firstcolumn) = latestdate)

     

    Replace Source with your previous step name throughout.

     

    Pat

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

guess

NewStep=Table.LastN(Table.Sort(OurTable,Table.ColumnNames(OurTable){0}))

Petri's avatar
Petri
Frequent Visitor
3 years ago

This seems to be on the right track but I got error:  "1 arguments were passed to a function which expects 2". If I modify the line by adding a number in the end:

 

 

NewStep=Table.LastN(Table.Sort(OurTable,Table.ColumnNames(OurTable){0}),3)

 

 

it gives me three rows each of which has the latest (30/09/2022) date. But if I try to replace '3' with something similar to the Last.Max in my original post, I get the same issue. I do not know how may rows there are for each date.