Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
78 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |