Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Syntax to fix

Experts, someone pls help me to fix the below DAX which is erroring out.     Thanks, Bala
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous try this one sec:

x Match - dp = IF((SEARCH("pass", Query1[Complaint Notes],,0)>0) ||
SEARCH("dp", Query1[Complaint Notes],,0)>0 ||
Query1[Complaint Amount]=75.12 &&
SEARCH("sdp", Query1[Complaint Notes],,0)=0, "dp", "")





      

Showcase Report – Contoso By SpartaBI

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your quick reply, Tried creating the same in new column but still it trows the error. pls help.

Should I create the column or Measure, If Measure How I can convert the text column it will consider?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    The formula should be a calculated column and there should be no problem with the formula itself.

     

    Please check these two columns for empty strings (""), you can replace and delete these values in Power Query.

    Or you can check them and then execute the formula:

    x Match - dp1 = 
IF (
    (
        NOT (
            'Query1'[Complaint Notes] = BLANK ()
                || 'Query1'[Complaint Notes] = ""
        )
    )
        && ( SEARCH ( "pass", Query1[Complaint Notes],, 0 ) > 0 )
        || SEARCH ( "dp", Query1[Complaint Notes],, 0 ) > 0
        || Query1[Complaint Amount] = 75.12
            && SEARCH ( "sdp", Query1[Complaint Notes],, 0 ) = 0,
    "dp",
    BLANK()
)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data