Forum Discussion

JK-1's avatar
JK-1
Icon for Helper II rankHelper II
1 year ago
Solved

IF statement and conditions

Hello, what would be the best way to run both these in DAX within the same statement. Switch / nested?  I can't quite work it through, grateful for pointers as a newbie.   Although only 2 condition...
IF statement help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JK-1,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.  And also thanks to Nasif_Azam , techies  and DataNinja777  for Prompt and helpful response.

     

    Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

    If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

     

    Best regards,

    Prasanna Kumar

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
1 year ago

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,

  • JK-1's avatar
    JK-1
    Icon for Helper II rankHelper II
    1 year ago

    Thank you all for these suggestions. If I just ignored CompanyNumber for now, and although wouldn't expect the Letter Received or Responded data to be blank would I have to list the variables below for a Check result achieved where either: Letter Received or Responded blank, or both blank.

     

    I've tested them as new - and think all are necessary, did some adaptations (separately) - so has been very useful in understanding the construction but wanted to make sure I wasn't adding in something extra in this slight follow on.

     

    reassessed = SWITCH(
        TRUE(),
        ISBLANK([Letter Received]) && NOT ISBLANK([Responded]),"Check",
        NOT ISBLANK([Letter Received]) && ISBLANK([Responded]),"Check",
        ISBLANK([Letter Received]) && ISBLANK([Responded]),"Check",
        "Pass"
    )