Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Syntax for If Statement

Experts, please help me to convert the below If statement captured from Business Objects report that I need to convert into DAX statement.   =If((Match(Lower([Complaint Notes]);"*pass*") Or (Match(...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , try a new column like

 


if ( (search("pass", [Complaint Notes],,0)>0 || search("dp", [Complaint Notes],,0)>0 || [Complaint Amount]=75.12)
&& search("sdp", [Complaint Notes],,0) = 0 , "dp", blank())

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Getting the below error, pls help.

 

 

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    It works fine in my side, could you share your sample file for us to check? thanks.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.