Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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_Deckler's avatar
    Greg_Deckler
    Community 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]
    • Anonymous's avatar
      Anonymous
      Not 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

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello everyone, has anyone been able to find a solution to this?
        thanks a lot. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello everyone, has anyone been able to find a solution to this?
    thanks a lot.