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...
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

     

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!