Filter max of a column in Power Query - M language

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

Thanks for your advice!