Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to get max from multiple columns in Power Query. I get an error , stating
"Expression.Error: We cannot convert the value 0.15 to type List.Details:
Value=0.15
Type=[Type]"
Any ideas how to remedy?
Solved! Go to Solution.
hello, @jcastr02 you are missing curley braces {} inside List.Max. There must be a list inside this function like this:
each List.Max({[Column1], [Column2],...,[ColumnN]})
hello, @jcastr02 you are missing curley braces {} inside List.Max. There must be a list inside this function like this:
each List.Max({[Column1], [Column2],...,[ColumnN]})
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.