Maximun value of several columns

[carenel]

Hello Community.

I would like to learn how to create a new column with the maximum value of several columns. is there any formula? because IF I use variables and IF linked, if I have to compare too many columns is a hell. 

Thank you in advance

Col A	Col B	Col C	Col D		Result_max
0,91	0,08	0,83	0,21		0,91
0,37	0,31	0,31	0,74		0,74
0,40	0,01	0,03	0,38		0,40
0,31	0,88	0,20	0,62		0,88

[mahoneypat · Accepted solution]

I would do it in the query too, but, if you can't, here is how to do it in a DAX column.

MaxCol = MAXX({Table[ColA], Table[ColB], Table[ColC], Table[ColD]}, [Value]) 

Pat

[carenel]

Many thanks, very elegant and simple solution.

[themistoklis]

@carenel 

You can do this through Power Query.

Go to Power Query

Select the relevant columns

From Menu on top Go to Add Column --> Click Statistics Button --> Select Max

The function used is List.Max

[carenel]

thank you but these columns are calculated and do not show in power query