We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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]})
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 7 | |
| 5 |