Solved: Filter max of a column in Power Query - M language

Anonymous · ‎07-10-2021

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 · ‎07-10-2021

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 · ‎07-10-2021

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 · ‎07-10-2021

Thanks for your advice!

Filter max of a column in Power Query - M language