Site logo white shadow

How to Eliminate VLOOKUP using Relationships in Power BI

VLOOKUP is one of the most commonly used functions in Excel.  However, it comes with its own set of problems:

  • It increases the file size
  • It consumes lots of processing power, making things slower
  • It is limited to a single table.  This means you cannot use VLOOKUP to search for a value in a different table or sheet
  • It only looks right
  • It can only handle a single criteria
  • If the lookup column contains duplicate values, it will match the first value only

With Microsoft’s Power BI, we now have a simpler and better alternative to handling VLOOKUP limitations using Relationships.  Watch this video to learn more:


Power BI Udemy Course coming very soon

This video is one of 30 lectures in my soon-to-be-released Power BI course on Udemy. It is my first ever course in the e-learning space. I am currently working on the last lecture, and the course  will be released in a matter of days. Watch this place for further announcements.

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,811 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.