Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
@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.
@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.
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |