Forum Discussion
Solved
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...
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
Hi PSB
I updated the link yesterday to reflect the changes to CONCATENATEX's delimiter.
I hope it works for you.
Hello PSB ,
You could add a calculated column with the following measure
Check Source in Target = IF('Table'[Source] = 'Table'[Target], "True","false")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍