Forum Discussion
Duplicating date hierarchies?
- Hi Anonymous
The hierarchies are virtual and not present in any table configuration so you need to replicate them manually on each table.
Regarding your question about the INACTIVE relationships if you make calculated measures with USER RELATIONSHIP you will then activate the inactive relationships and filters will work according.
Don't believe the best way is to duplicate a calendar table, but youneed to do what is better for your model.
Regards,
MFelix
Hi MFelix
Thanks for your reply.
Usual reasons - different fact tables with different date ranges - I believe that if a date used by an inactive relationship is not available via an active relationship I will not be able to filter on it (as the active relationship passes the filter?) + some issues with self service being a bit easier with specific named date dimensions.
Some of my 'date' hierarchies are custom (for specific company reporting requirements) e.g. not specifically Y>Q>M>D. If I've understood you correctly, these hierarchies will not propogate automatically by changing the table into a Auto Date table.
So, is there a way to either create a query with hierachies in PowerQuery and duplicate hierarcies within PowerQuery? Or import a table into PBI and duplicate the table with hierachies in PBI itself?
Thanks :)
Super UserThe hierarchies are virtual and not present in any table configuration so you need to replicate them manually on each table.
Regarding your question about the INACTIVE relationships if you make calculated measures with USER RELATIONSHIP you will then activate the inactive relationships and filters will work according.
Don't believe the best way is to duplicate a calendar table, but youneed to do what is better for your model.
Regards,
MFelix