Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Another method
Column2 =
VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34)
VAR _result = IF([Retailer]=_text,"Yes","No")
return _result
Another method
Column2 =
VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34)
VAR _result = IF([Retailer]=_text,"Yes","No")
return _result
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
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
User | Count |
---|---|
57 | |
33 | |
18 | |
18 | |
15 |
User | Count |
---|---|
94 | |
86 | |
39 | |
23 | |
22 |