Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
there are a few ways to do what you are asking for.
What is your purpose? are the two tables in the same format?
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |