Forum Discussion

sm88483's avatar
sm88483
Frequent Visitor
4 years ago
Solved

How to automatically filter for max value

I want power query to automatically filter for the most recent date in the date column.   The current code is shown below, in the last line of code there is the date field which is manually input, ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Prices1.Date] = List.Max(#"Changed Type"[Prices1.Date]))

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Replace #date(2022, 6, 23) with

Date.From(DateTime.FixedLocalNow())

sm88483's avatar
sm88483
Frequent Visitor
4 years ago

Thanks for the response. Would that just be filtering for today's date? If so, today's date may not be actually in the dataset yet, I would need it to look at the column and find the largest date that is contained in the dataset.