Link two tables with two relationships

[smquerido]

Sorry about the question but these are my first steps in Power BI after some experience in Tableau.

I have 2 tables from different sorces with two relationships (Athlete and Date) but Power BI just allow one active relationship. I need to link the variable sRPE of each Athlete in each Date from RPE Table to each Athlete in each Date in BD Table.

How can i solve the issue?

Thanks!

[smquerido]

@v-zhangti thank you very mutch for your reply, it really helped me.

I also share that I found another solution using Power Query and merging the variables.

Thank you.

Best regards,

SQ

[v-zhangti · Accepted solution]

Hi, @smquerido 

The function USERELATIONSHIP can make an inactive relationship active at the time of operation.

For reference:

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive#inactive-relations... 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.