List.Max with date format not working

[Jebilaya]

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!

[jgordon11 · Accepted solution]

try using lower case c in both places ie., #"Removed columns" .  Make sure the step name is identical to what you are referencing

[jgordon11]

= Table.SelectRows(#"Removed Columns", let max = List.Max(#"Removed Columns"[Report Date]) in each [Report Date] = max)

[Jebilaya]

I get the module reference error with that @jgordon11