DAX Syntax to fix

Question

Experts, someone pls help me to fix the below DAX which is erroring out.&nbsp;&nbsp;Thanks,Bala

amitchandak · Answer

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.
&nbsp;

anonymous · Answer

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 · Answer

Anonymous&nbsp;try this one sec:x Match - dp =&nbsp;IF((SEARCH("pass",&nbsp;Query1[Complaint Notes],,0)&gt;0) ||SEARCH("dp",&nbsp;Query1[Complaint Notes],,0)&gt;0&nbsp;||Query1[Complaint Amount]=75.12&nbsp;&amp;&amp;SEARCH("sdp",&nbsp;Query1[Complaint Notes],,0)=0,&nbsp;"dp",&nbsp;"")In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.SpartaBI LogoVisit SpartaBI website&nbsp;&nbsp;&nbsp;Visit SpartaBI Linkdin &nbsp;&nbsp;Visit SpartaBI FacebookShowcase Report – Contoso By SpartaBI

anonymous · Answer

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 · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
The formula should be a calculated column and there should be no problem with the formula itself.
&nbsp;
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] = ""
        )
    )
        &amp;&amp; ( SEARCH ( "pass", Query1[Complaint Notes],, 0 ) &gt; 0 )
        || SEARCH ( "dp", Query1[Complaint Notes],, 0 ) &gt; 0
        || Query1[Complaint Amount] = 75.12
            &amp;&amp; SEARCH ( "sdp", Query1[Complaint Notes],, 0 ) = 0,
    "dp",
    BLANK()
)
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;How to provide sample data

Forum Discussion

DAX Syntax to fix

5 Replies

Related content

Syntax problem

DAX syntax highlighting in Notepad++

DAX syntax error for ...

SQL Query Syntax issue

DAX syntax