Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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
Try it like this:
#"Filtered Rows2" = let MaxVal = List.Max(#"Changed Type"[Custom.1]) in Table.SelectRows(#"Changed Type", each [Custom.1] = MaxVal))
--Nate
Thanks for your advice!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
11 | |
9 | |
6 | |
6 |