Forum Discussion

wkelly1002's avatar
wkelly1002
Frequent Visitor
8 years ago
Solved

Need help with DAX equation

I am trying to create a calculated column with a DAX equation that checks a few columns for certain parameters.   The first part is checking to see if "POE" is in the "POE Chargeable" column. If "P...
Need Help
Tips and Tricks
Tutorial Requests
  • abbasabdulla's avatar
    abbasabdulla
    8 years ago

    Hi,

    Try using this DAX

    IF('Active RCA Audit'[POE Chargeable]="POE",
BLANK(),If(OR(SEARCH("Procedural",'Active RCA Audit'[DIRECT CAUSE],1,FALSE()),SEARCH("Procedural",'Active RCA Audit'[ROOT CAUSE],1,FALSE())),"Potential",BLANK()))

     

abbasabdulla's avatar
abbasabdulla
Frequent Visitor
8 years ago

Hi,

Try using this DAX

IF('Active RCA Audit'[POE Chargeable]="POE",
BLANK(),If(OR(SEARCH("Procedural",'Active RCA Audit'[DIRECT CAUSE],1,FALSE()),SEARCH("Procedural",'Active RCA Audit'[ROOT CAUSE],1,FALSE())),"Potential",BLANK()))

 

  • wkelly1002's avatar
    wkelly1002
    Frequent Visitor
    8 years ago

    That worked! Thank you