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.
I need help with an if Formual. I have a colum that contains a value. I need to "rate" that value based on if.
If MU Diff >0,1
If MU Diff > .5,2
If MU Diff >1,3
If MU Diff >2,4
otherwise 0
What is the DAX Equivleant of that?
You're not too far away.
The syntax for nested IFs in DAX can begin to look messy but you just need some additional commas to separate the clauses.
More importantly, you need to reverse the IF clauses in this case because you will only get two value comparisons using the current order : is MU greater than 0? if yes, then return 1, and the second clause will never get tested for positive numbers e.g. if MU is 0.75
so the DAX should look something like
Column = if (MU Diff > 2, 4, IF (MU Diff > 1, 3, IF (MU Diff > 0.5, 2, 0)))
I deliberately missed a clause for you to put in
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
18 |