Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Experts, please help me to convert the below If statement captured from Business Objects report that I need to convert into DAX statement.
@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())
Getting the below error, pls help.
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.