Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

  • Thomas LeBlanc

    SSCertifiable

    Points: 7741

    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: 15

    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

    SSCertifiable

    Points: 7741

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply