Colander Table With Two Date Replationship

[NewbieJono]

Hello, i have a calendar table linked to another table called "Total" via a column called Received date.

On some pages of my report, I want to use another date column from the "Total" Table.  This column is called "Completion date".

i am not sure how to handle this as there is only one active connection allowed, do I have two calendar tables. should I split out all the completions from the "Total" table.

Thank you

[miTutorials]

Check out this tutorial below.

Dealing with Multiple Date Fields to bring values from same time period in Power BI | MiTutorials (y...

[Jpss · Accepted solution]

You dont need a second date table. Instead, in this scenario, you create two relationships. 

1) Active

2) Inactive. 

Where ever you need to use the inactive relationship, you can use Userelationship DAX Function