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.