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