How to find the max of rows from 5 different columns

[Khushboo9966]

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.

[parry2k · Accepted solution]

@Khushboo9966 here is my recommendation, if it is a DQ, I would recommend adding view at the backend and having this column calculated there (this is a way to go) but if you cannot do that then do this:

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

[Khushboo9966]

I was missing the UNION association. Do you mind explaining the formula?

[newtodax]

Doing this in power query would probably be the easiest way 

[Khushboo9966]

This is the error I get: The syntax for 'Max' is incorrect. (DAX(List.Max({'App'[Level 1],'App'[Level 2],'App'[Level 3],'App'[Level 4],'App'[Level 5]}))).

[parry2k]

@Khushboo9966 are you looking for a PQ or DAX solution? 

[Khushboo9966]

I am looking for Calculated Column DAX. The data is coming from direct query so PQ is not an option.