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

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , seems fine in the screenshot. Can you share the formula in text format to check


    Can you share a sample pbix after removing sensitive data.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Amit for your quick response, Not able to the .pbix file for your reference. Please help me to fix the same with Syntax in the below for creating the column.

     

    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", BLANK())
    • SpartaBI's avatar
      SpartaBI
      Community 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?