Forum Discussion
Multiple Date Columns in FACT Tables
I would say have multiple relationships and use USERELATIONSHIP to determine which one should be active for a given measure. Depending on your use case, a calculation group could be a good option with a calculation item per date. This would allow you to apply the same logic to all of your measures.
However, if you want to be able to show 2 different versions in the same e.g. line chart I don't think calculation groups would work, you would need to define the different measures each using their own USERELATIONSHIP
I would say have multiple relationships and use USERELATIONSHIP to determine which one should be active for a given measure. Depending on your use case, a calculation group could be a good option with a calculation item per date. This would allow you to apply the same logic to all of your measures.
However, if you want to be able to show 2 different versions in the same e.g. line chart I don't think calculation groups would work, you would need to define the different measures each using their own USERELATIONSHIP
Thank you, that is most helpful
