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 table by category and then add the forecast number to that category.  I have the forcast data in a seperate table and I am trying to connect the two tables by category but it I get this error message. "You can't create a relationship between these two columns becuase one of the columns must have a unique values.

 

Any suggestions?

 

Thank you,

 

Joseph

 

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.

     

     

4 Replies