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...
Need Help
  • 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
    grantsamborn
    3 years ago

    Hi PSB 

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

    I hope it works for you.

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

Hi PSB 

I made a couple of transformations in Power Query:

- separate Source from Target

- unpivot both tables

- create DimCell

After that, there is a single measure to concatenate any values that weren't found.

Let me know if this works.

 

(edited to change link - I forgot the delimiter in CONCATENATEX.)

https://1drv.ms/u/s!AnF6rI36HAVkhPIcSilVrS2tpNBEQg?e=ApDvy6

 

PSB's avatar
PSB
Helper III
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
    grantsamborn
    Solution Sage
    3 years ago

    Hi PSB 

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

    I hope it works for you.