ssastabulardimensionsssas-tabularfact

SSAS Tabular model: two relations with the same dimension table

I need to create a tabular model with ssas but in a fact table I have two relations with the same dimension (time).

How is it best to handle this? Duplicating the dimensions table ?

Thanks

Solution

  • Thanks for your answer, this model is going to be used by business user and the haven't deep knowledge of dax.

    I can't develop all the measures several times (also because it is about 4 dates per table and about fifty measures).

    Whant do you think about this: https://www.biinsight.com/role-playing-dimension-ssas-tabular/#more-1068

    Thanks