Forum Discussion
Multiple relationship between 2 tables
Hello everybody !
I have 2 tables:
Table 1: | sector | billing | date |
Table 2: | Person | salary | date | sector |
I have to do a report to show salary/billing by sector, using both filters (date and sector).
PowerBi does not allow me to relate sector and date between both tables.
If i relate just date, i can´t filter by sector. if i relate sector i can´t filter by date.
So, if i use USERELATIONSHIP, just allow 1 relationship, not both.
How can i solve this?
Regards!
4 Replies
- Greg_DecklerCommunity Champion
Anonymous Not sure I fully understand the situation, but perhaps create a combination key in both tables and relate the tables on that key, something like:
Key Column = [sector] & "|" & [date]- AnonymousNot applicable
Thanks for your answer.
I have 2 tables, and i need to show in the same table.
Above you can see the two tables and below what I need. Actually they are not related so it shows the same value repeated.
I will appreciate your response.
Regards- AnonymousNot applicable
Hello everyone, has anyone been able to find a solution to this?
thanks a lot.
- AnonymousNot applicable
Hello everyone, has anyone been able to find a solution to this?
thanks a lot.