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(Lower([Complaint Notes]);"*dp*")) Or ([Complaint Amount]=75.12)=1) And Match(Lower([Complaint Notes]);"*sdp*")=0;"dp";"")

3 Replies

  • 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.