Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there an easy way to create a measure which returns the MIN or MAX value of MULTIPLE calculated columns?
The other way for me could be unpivoting all my calculated columns and apply MIN formula to the unpivoting resulting column. I posted another question to ask how to unpivot multiple calculated columns since I'm able to unpivot only columns of the original datasource in the query editor, but not when I have calculated columns, if it could be useful to someone else...
Solved! Go to Solution.
Hi @AGo,
According to your description, you want to get the Max or Min value of MULTIPLE calculated columns, right? Suppose your sample data is like below, and the Max value returned should be 5.
If that is the case, you can refer to the below formula:
Measure = MAX ( MAX ( CALCULATE ( MAX ( Table2[Event1] ), ALL ( Table2 ) ), CALCULATE ( MAX ( Table2[Event2] ), ALL ( Table2 ) ) ), CALCULATE ( MAX ( Table2[Event3] ), ALL ( Table2 ) ) )
Thanks,
Yuliana Gu
Hi @AGo,
According to your description, you want to get the Max or Min value of MULTIPLE calculated columns, right? Suppose your sample data is like below, and the Max value returned should be 5.
If that is the case, you can refer to the below formula:
Measure = MAX ( MAX ( CALCULATE ( MAX ( Table2[Event1] ), ALL ( Table2 ) ), CALCULATE ( MAX ( Table2[Event2] ), ALL ( Table2 ) ) ), CALCULATE ( MAX ( Table2[Event3] ), ALL ( Table2 ) ) )
Thanks,
Yuliana Gu
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |