Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
salilphatak
New Member

Comparing 2 columns with data

‎05-24-2017 07:09 AM

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?

 

 

Labels:
Message 1 of 3
683 Views
0
2 REPLIES 2
Anonymous
Not applicable

‎05-25-2017 02:56 AM

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

Message 3 of 3
666 Views
0
vanessafvg
Super User
Super User

‎05-24-2017 07:41 AM

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

 

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 2 of 3
680 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All