Forum Discussion
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, but I shouldn't do that because my column id get multiplied.
Also, I saw a solution in DAX but I would like it in the Power Query - M.
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
2 Replies
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
