Forum Discussion

joschultz's avatar
joschultz
Advocate II
10 years ago
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...
Need Help
  • Rémi's avatar
    Rémi
    10 years ago

    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.

     

     

Rémi's avatar
Rémi
Resolver III
10 years ago

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.