Forum Discussion
PSB
3 years agoHelper III
Compare two cells using DAX or Power Query
I want to check if all values in Souce column exist in Target Column. If I can get True or False, it's good. If I can get Exact value that's missing, it's better. Cell_Id Source Target C...
- 3 years ago
your solution worked perfectly. Can't thank you enough for your help.
Only thing I need is "," between the result like shown below.
Actual Result: Missing 126490389090
Result I need: Missing 126490,389090
- 3 years ago
Hi PSB
I updated the link yesterday to reflect the changes to CONCATENATEX's delimiter.
I hope it works for you.
PSB
3 years agoHelper III
I want to flag as true even if source is "123-234" and Target is "012-123-234-013"