Multiple IF Statements

Camstr — Fri, 03 Nov 2023 11:02:46 GMT

Hello,

I need to create a calculated column based on test results. I believe I need multiple IF/AND type logical functions to create my DAX expression, but I cannot write this properly. An example of the data is below, with the calculated column furthest right.

There are two types of test, Manual and Automated.

For a manual test, Result 1

Operates = Pass
Partial = Warning
Stuck = Fail

For an automated test Result 1 must = Operates

Result 2 <40 = Pass,
40-50 = Warning,
>50 = Fail

I appreciate some help generating the DAX for this.

Thank you

Re: Multiple IF Statements

MurtuzaMomin — Fri, 03 Nov 2023 11:43:25 GMT

Here is your Solution with Switch function instead of using multiple If statement.

Re: Multiple IF Statements

Camstr — Fri, 03 Nov 2023 14:03:30 GMT

Thanks MurtuzaMomin! SWITCH is a better way to go, works perfectly.

topic Re: Multiple IF Statements in DAX Commands and Tips

Multiple IF Statements

Re: Multiple IF Statements

Re: Multiple IF Statements