Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |