Forum Discussion
Solved
Custom Column not working
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]="...
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/
amitchandak , works okay now. Thank you!
