Forum Discussion
Creating relationships between two tables.
Hi,
Here a little example for understand how work a relationship :
Car sales :
You have a first table 'Sales', each row correspond to one sale, and you have many informations about that : the customer, the price, the car(s), etc ...
Then you have a table 'Customer' with the name/surname/full name/address/phone number/etc ...
You can create a relation from Sales to Customer if the Sales[Customer] column got the number (generally said Id) of the customer.
After that, you can display the sales by customer into Power BI without more steps.
If you need to link two sets of data which are at different granularities then you need a common lookup table rather than link directly between the two tables.
Have a look at these links
http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/
http://www.daxpatterns.com/handling-different-granularities/
Is it possible to get an updated Solution?
The PowerPivot site is really interesting but the link to the full solution is broken.
Does anyone have an updated version: