Post reply

Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

  • 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

  • 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

  • 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

  • March 26, 2024 at 1:15 pm

    This was removed by the editor as SPAM

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

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