VLOOKUP in PowerPivot 2010 and 2013

PowerPivot for Excel and SharePoint is an extraordinary tool to provide Business Intelligence capabilities to information analysts.  DL clients are amazed at the how easy and customizable PowerPivot is for the savvy Excel user and how it can provide organizations with data analytical tools without spending a fortune. Among the great features of PowerPivot is Data Analysis Expressions or DAX for short. DAX is a powerful language in PowerPivot which can be used to build custom calculations. For clients exploring the DAX language one question that I frequently get is how can you use VLOOKUP in PowerPivot? Unfortunately VLOOKUP is not available in PowerPivot.  HOWEVER, there are other ways to accomplish the same objective. Lookup Between Two Tables using the…