Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

• Thomas LeBlanc

  SSCrazy Eights

  Points: 8085

  More actions

  September 12, 2018 at 12:00 am

  #379081

  Comments posted to this topic are about the item Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

  Thomas LeBlanc, MVP Data Platform Consultant

• kalpani

  Grasshopper

  Points: 17

  More actions

  September 27, 2018 at 12:37 am

  #2007192

  Hi Thomas,

  Thank you for the descriptive series of articles related to SSAS Tabular.

  I have one question here regarding multiple foreign keys to Date dimension.
  What if we duplicate the Date table and added it twice to represent Invoice Date and Delivery Date separately? Is it an acceptable practice? 
  I'm a novice to Tabular so your opinion is really helpful.

  Thanks

• Thomas LeBlanc

  SSCrazy Eights

  Points: 8085

  More actions

  September 27, 2018 at 7:11 am

  #2007211

  Yes, you can have separate Date dimensions/tables in a tabular model like you described. A later article will give this example along with a suggestion from Patrick LeBlanc on using DAX Cross Join in measures.

  Thomas LeBlanc, MVP Data Platform Consultant