Need Help with an "if" formula

Anonymous — Tue, 09 Jul 2019 23:39:43 GMT

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?

Re: Need Help with an "if" formula

HotChilli — Wed, 10 Jul 2019 11:05:35 GMT

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

topic Re: Need Help with an "if" formula in DAX Commands and Tips

Need Help with an "if" formula

Re: Need Help with an "if" formula