Forum Discussion
Solved
Handling multiple dates in a dimension
I have a Dimension which contains multiple dates. To support reporting I need the date hierrachy for each of these dates. Will creating alias of the date in a snowflake structure create performance o...
vini_udenia , I would prefer to merge these dates into the fact.
Now I can three date dimensions joined to fact.
Or use one date dimension and all three dates joined to that and use userelationship for inactive datesin a measure
Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thank you. In my case merge into Fact makes sense as the power users will also be using the data set.