O'Reilly logo

PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Table Relationships

One of PowerPivot for Excel’s current limitations is that there is no direct means of creating relationships between tables based on multiple columns. You can use DAX expressions as a way of crafting a workaround.

Understanding the Problem

One of the limitations in the initial release of PowerPivot for Excel concerns relationships between tables. At this time, PowerPivot for Excel only supports one-to-one and one-to-many relationships between tables.

A one-to-one relationship exists where a given row in one table is related to at most one row in a lookup table. Figure 4-9 illustrates a one-to-one relationship between a table of employees and a table of spouses. Each employee row would have at most one related row in the spouse ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required