Creating Relationships in PowerPivot
How to create relationships in PowerPivot?
You have followed the previous training video and imported information from database tables into PowerPivot. You now need to forge relationships between the tables to ensure that all your DAX expressions return accurately.
If you have yet do so please check out either the PowerPivot Excel 2013 installation or the Building data models with PowerPivot training videos.