IF statement and conditions

Hi JK-1 ,

The best and most recommended way to write this logic in DAX is by using the SWITCH function.

This approach is cleaner, easier to read, and more scalable than nested IF statements, making it a best practice for handling multiple conditions. It evaluates each condition in order and returns the result for the first one that is true.

YourNewColumn =
SWITCH(
    TRUE(),
    CONTAINSSTRING(Table[CompanyNumber], "Company2") && Table[Letter Received] = "No" && ISBLANK(Table[Responded]), "Check",
    Table[CompanyNumber] <> "Company2" && Table[Letter Received] <> "No" && ISBLANK(Table[Responded]), "Check",
    "Pass" // This is the default result if no other condition is met
)

Best regards,

Hi JK-1 if you prefer to use nested if, please try this calculated column

Result =
IF (
Table[CompanyNumber] = "Company2",
IF (
Table[Letter Received] = "No" && ISBLANK(Table[Responded]),
"Check",
"Pass"
),
IF (
Table[Letter Received] <> "No" && ISBLANK(Table[Responded]),
"Check",
"Pass"
)
)

Hey JK-1 ,

You're on the right track, and yes you can handle this logic using SWITCH, IF, or a combination of both, but in your case with only two conditions and some AND/ISBLANK logic, a nested IF structure is easier and more appropriate than SWITCH.

Let's first clarify your intent in plain logic:

1. If CompanyNumber = "Company2" AND Letter Received = "No" AND Responded is blank → "Check"

2. If CompanyNumber ≠ "Company2" AND Letter Received ≠ "No" AND Responded is blank → "Check"

3. Else → "Pass"

Corrected and Optimized DAX

Result =
IF (
    (Table[CompanyNumber] = "Company2" && Table[Letter Received] = "No" && ISBLANK(Table[Responded])) ||
    (Table[CompanyNumber] <> "Company2" && Table[Letter Received] <> "No" && ISBLANK(Table[Responded])),
    "Check",
    "Pass"
)

Explanation

• I combined your two conditions using an OR (||) operator at the outer level.

• Each condition group is clearly separated using parentheses.

• This avoids deeply nested IFs and improves readability.

Why Not SWITCH?

SWITCH works best when you're checking a single column against many constant values. Since you're testing multiple columns and a combination of boolean expressions, SWITCH would require complex nesting and doesn't simplify the logic here.

If you expect to scale this logic with more conditions, you could modularize the logic into variables using a calculated column:

Result =
VAR IsCompany2Check = Table[CompanyNumber] = "Company2" && Table[Letter Received] = "No" && ISBLANK(Table[Responded])
VAR IsOtherCheck = Table[CompanyNumber] <> "Company2" && Table[Letter Received] <> "No" && ISBLANK(Table[Responded])
RETURN
    IF (IsCompany2Check || IsOtherCheck, "Check", "Pass")

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam