Max Value Different Columns - Power Query

[Antonio_Gomez]

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]

What a great simple solution, thanks a lot!!!! @amitchandak 

[amitchandak · Accepted solution]

@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