Forum Discussion
sm88483
4 years agoFrequent Visitor
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, ...
- 4 years ago
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Prices1.Date] = List.Max(#"Changed Type"[Prices1.Date]))
wdx223_Daniel
4 years agoCommunity Champion
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Prices1.Date] = List.Max(#"Changed Type"[Prices1.Date]))