Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Date Relationships - between 2 tables

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 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.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion

      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.