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!Get Fabric certified for FREE! Don't miss your chance! Learn more
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 January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 12 | |
| 12 | |
| 10 | |
| 6 | |
| 5 |