The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
33 | |
20 | |
16 | |
15 |
User | Count |
---|---|
56 | |
50 | |
36 | |
35 | |
31 |