Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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] )
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] )
MaxRow = MAXX(App, MAX(App[Level1], App[Level2], App[Level3], App[Level4], App[Level5]))
Let me know if this works
User | Count |
---|---|
50 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
63 | |
28 | |
18 | |
13 |