Forum Discussion
Solved
using one date table for multiple dates (For a drill through table)
I have a star schema in Power BI My date is marked as date which removes the hierarchy table from the date field and I create my own. The Active Join is on Received Date All my measures so f...
Ive created a blob post for this which hopefully answers the question
Hi DebbieE ,
I guess you could duplicate your calendar table for each of the fact dates, for example:
- calendarReceived
- calendarStart
- calendarClosed
or similar, then create active relationships between each of these to the relevant fact table date. You could then use the different calendar dates as each level in the drillthrough.
Not going to save you any model space, but a 'quick & dirty' solution nonetheless?
Pete
I dont want to do that though as adding date tables for each will create a bigger model