Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Please assist whats wrong with below. It doesn't seem to filter properly.
Table.AddColumn(#"Added Conditional Column", "Dupli", each if [Count]>1 and [LODT]="null" and [DCHT]="null" then "YES" else "NO")
I've already tried >1 / ="2" / =2 / but still all data in that column shows NO even though there are thousands that should have YES value.
In DAX, I have successfully created it as below but I need to create the columns directly in power query to filter the duplicates out.
Thank you.
Regards,
Dina
Solved! Go to Solution.
@dnsia , Try like
Table.AddColumn(#"Added Conditional Column", "Dupli", each if [Count]>1 and [LODT]=null and [DCHT]=null then "YES" else "NO")
refer
http://excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
@dnsia , Try like
Table.AddColumn(#"Added Conditional Column", "Dupli", each if [Count]>1 and [LODT]=null and [DCHT]=null then "YES" else "NO")
refer
http://excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |