Forum Discussion

PSB's avatar
PSB
Helper III
3 years ago
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...
  • PSB's avatar
    PSB
    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

  • grantsamborn's avatar
    3 years ago

    Hi PSB 

    I updated the link yesterday to reflect the changes to CONCATENATEX's delimiter.

    I hope it works for you.