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

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

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"
)
)