Forum Discussion
Solved
Max Value Different Columns - Power Query
Hello Everyone, I need some help, I have a table with severals columns and from three of them I want to know the max value for each row. I saw other solution in which they unpivot the columns...
Antonio_Gomez , if you need row wise then you should be able to List.Max
List.Max({[Col1], [Col2], [Col3]})
For the column-wise refer to video
List.Max and List.MaxN : https://youtu.be/22a8fq2UeBw
What a great simple solution, thanks a lot!!!! amitchandak