Combine two files (or fact tables) in PowerPivot using relationships, relationships explained

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

I had a conversation last week with a Excel power user who wanted to combine data he got delivered from his sales department in a csv file and data in one xlsx file with the target of the sales.

He had difficulty understanding how he can combine these two in PowerPivot. Although he had seen some demo’s and read some blog posts about fact tables, dimension tables and relationships and he still was unable to get these 2 sources combined.  In this blog post we are going to combine two fact table by creating a relationship and take a look at how relationships work.

Read more...

 

Tags: excel, design

 

2007-2015 VidasSoft Systems Inc.