How to find the max of rows from 5 different columns

[Khushboo9966]

How to find the max of rows from 5 different columns

49 seconds ago

I have a table called App with three calculated columns Level1, Level2, Level3, Level4, Level5. 

Level1	Level2	Level3	Level4	Level5
0	2	3	0	5
1	2	0	0	0
1	0	0	4	0
0	0	3	0	5

I need to write a calculated column formula to find the max of each row. For example: For row1: Max of 0,2,3,0,5 is 5 and likewise for all rows.

[Khushboo9966 · Accepted solution]

Thank you. The above formula won't work because Max allows only 2 arguements. 

@parry2k provided the below solution and it worked. 

Column = MAXX ( UNION ( { [Level1] }, { [Level2] }, { [Level3] }, { [Level4] }, { [Level5] } ), [Value] )

[DallasBaba]

@Khushboo9966 

MaxRow = MAXX(App, MAX(App[Level1], App[Level2], App[Level3], App[Level4], App[Level5]))

Let me know if this works