topic Quotation mark in Text Filter in DAX Commands and Tips

Quotation mark in Text Filter

User777 — Wed, 16 Aug 2023 11:01:19 GMT

I am having trouble to filter data in new column:

I have new column which i want to be filled like

Column 2 = if( [Retailer] = """KDK""", "YES", "NO")

The data i am looking for in column Retailer is "KDK"

Above syntax doesnt work for me for some reason, please give better solution

Thanks in advance.

SamInogic — Wed, 16 Aug 2023 11:45:19 GMT

Hi User777

It should work with your expression as shown in below screenshot,

Could you please provide any screenshot of your incorrect output or error message ?

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

nandukrishnavs — Wed, 16 Aug 2023 11:52:10 GMT

Another method

Column2 = VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34) VAR _result = IF([Retailer]=_text,"Yes","No") return _result