Multiple Date Relationships - between 2 tables

[Anonymous]

Hi all 

My dashboard has a table that contains multiple date fields (between other fields) and im using a date table that contains the full date ( the key) and a bunch of other useful fields (like week number). here's how it looks like

Table 1		Date Table
Start Date		Full date (the foreign key
End Date		Week number
Submitted date		Quarter number
Requested date
Approved date

I want to show different stats based on different dates. Example a chart showing volume of tickets that were submitted and another chart volume of tickets that were approved. 

Also I want to add in the Week number from the Date table ( which is why I need all those dates to be connected)

i created the relationships but only one can be active so my other charts doesnt display the right data. 

I know I can use DAX : Userelationship. but I have so many differnet measures so I would need to create a ton of calculations. 

Is there another way? 

thanks

[Anonymous]

Thanks @Greg_Deckler. Do you think thats the only other way? 

[Greg_Deckler]

@Anonymous Pretty sure. You could also just go with a disconnected table for your Calendar but you're back in the same boat as USERELATIONSHIP.

[Greg_Deckler · Accepted solution]

@Anonymous The other way is to duplicate your date table and thus have multiple "role-playing" dimensions, one for each date in your fact table. "Start Dates", "End Dates", "Requested Dates", etc.