3 Ways to SIMPLY Compare Matching Values Across Two Files Using Power Query | #powerbi

In this short Power Query tutorial, I demonstrate 3 simple ways to compare table values across different files. The files originate from SQL & Excel and it's a great way to check data accuracy between migrated data or live data vs static data that Stakeholders control.

Enjoy!

🤝 Connect with me on LinkedIn:

🤝 View my Website:

🖥📝 I also have a great value 2 hour data career consultation service to get you on the right track. Covering resumes, ATS, data technology, soft skills, roadmaps and a take home document pack at great value. Check out the Fiverr gig below:

[TheRubyKnite]

Awesome, exactly what I needed. Simply explained and easy to understand.

[mans]

What’s the best way to call out line items that have been removed from the “new” data pull or have been added to the new pull? Also, what’s the best way to call out individual data fields that have changed?