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.

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST 

//linkedin insights tag added by nitin on 30 oct 2020