Forum Discussion
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_DecklerCommunity 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.
- AnonymousNot applicable
Thanks Greg_Deckler. Do you think thats the only other way?
- Greg_DecklerCommunity 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.