Forum Discussion
Data realtion ship
Hi All,
Am totally new with power Bi I have problem with relationships. I have two table in 1st table I have (branch name;code,month ,year ,sales ,GM,contribution,Ebitda,)also same for other table for last year I don't know what should I change how can I make relation between them I got text that I have some unique values.pleased to have your guidance.
Thanks
Am totally new with power Bi I have problem with relationships. I have two table in 1st table I have (branch name;code,month ,year ,sales ,GM,contribution,Ebitda,)also same for other table for last year I don't know what should I change how can I make relation between them I got text that I have some unique values.pleased to have your guidance.
Thanks
1 Reply
Table relationships should be a field that appears in both tables. You want to be look at the data in a single row of 1 table and get a consistant answer from the other table.
For example, you might have a table which is all of the Sales People. Each Sales Person has a unique Identifier. You might also have a sales table, which contains everything that is sold and there is a column which holds the Sales Person unique identifier of the person who made the same.In that example, you would do a link between the Many sales and the 1 Sales person.
The relationships should be how you want to relate the data. So ask yourself, what is the relationship between your tables conceptually?
