Forum Discussion

salilphatak's avatar
salilphatak
New Member
9 years ago

Comparing 2 columns with data

Hi,

 

I am a new user and believe power BI is easier than vlookup. I have 2 excel sheets - both have a column called 'Mobile Numbers' - I need to isolate the ones which are common between these sheets. How do I do this?

 

 

Need Help

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    there are a few ways to do what you are asking for.

     

    What is your purpose?   are the two tables in the same format?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi salilphatak,

     

    So you want to get common phone number, right? If this is a case, you can use the INTERSECT Function (DAX) to get the common numbers.

    In addition, if above not help, please share some detail content of your requirement.

     

    Regards,

    XIaoxin Sheng