Forum Discussion
Solved
List.Max with date format not working
I'm trying to filter a table in power query so that it only shows results from the max date within the report date column but my List. Max doesn't work as can't be converted to list.
I've also tried using change type but then get a module reference error
Help!
try using lower case c in both places ie., #"Removed columns" . Make sure the step name is identical to what you are referencing
3 Replies
= Table.SelectRows(#"Removed Columns", let max = List.Max(#"Removed Columns"[Report Date]) in each [Report Date] = max)
try using lower case c in both places ie., #"Removed columns" . Make sure the step name is identical to what you are referencing
