Comparing 2 columns with data

[salilphatak]

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?

[Anonymous]

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

[vanessafvg]

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

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