Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter max of a column in Power Query - M language

Dear all,

 

Could you please advise the formula to filter max value in a column in Power Query?

 

Below is my formula but there is Expression.Error with this formula: We cannot convert a value of type Table to type List.

 

#"Filtered Rows2" = Table.SelectRows(#"Changed Type", each [Custom.1] = List.Max( #"Changed Type",[Custom.1]))

 

 

Thanks for your support!

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Try it like this:

     

     #"Filtered Rows2" = let MaxVal = List.Max(#"Changed Type"[Custom.1]) in Table.SelectRows(#"Changed Type", each [Custom.1] = MaxVal))

     

    --Nate

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Try it like this:

     

     #"Filtered Rows2" = let MaxVal = List.Max(#"Changed Type"[Custom.1]) in Table.SelectRows(#"Changed Type", each [Custom.1] = MaxVal))

     

    --Nate

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for your advice!