Solved: Re: Filter max of a column in Power Query - M lang...

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!

watkinnc · ‎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

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

watkinnc · ‎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

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Anonymous · ‎07-10-2021

Thanks for your advice!

Filter max of a column in Power Query - M language

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024