DAX Syntax for If Statement

[BalaKiranM]

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";"")

[amitchandak]

@BalaKiranM , 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())

[BalaKiranM]

Getting the below error, pls help.

[v-xiaotang]

Hi @BalaKiranM 

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.