End of Excel VLOOKUPS – Power Pivot Relationships

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Do you suffer from Excel VLOOKUP fatigue? The life of an Excel user inevitably involves combining data from various sources. And that, typically involves a generous use of VLOOKUPs.

We, at PowerPivotPro, argue that Excel is the best BI tool in the world; it’s our superhero (and of millions of business users who use it daily). However, the “old” Excel has some dark corners. For instance, the use of VLOOKUPs is problematic in cases such as

Read more...

 

Tags: dax, design

 

2007-2015 VidasSoft Systems Inc.