Forum Discussion
Solved
Creating relationships between two tables.
Is the purpose of creating relationships between two tables so that you can use them in the same visual? I have a sales data table that is at a product level detail but I need to sum them in a ta...
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.
