Forum Discussion

Jebilaya's avatar
Jebilaya
Icon for Helper III rankHelper III
3 years ago
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!

 

Need Help
  • jgordon11's avatar
    jgordon11
    3 years ago

    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

  • jgordon11's avatar
    jgordon11
    Icon for Resolver II rankResolver II
    3 years ago

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

  • jgordon11's avatar
    jgordon11
    Icon for Resolver II rankResolver II
    3 years ago

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