Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Date/Calendar Table

I have a table of dates (every date from 2003 to 2035) in my data model but am wondering if I need to create relationship(s) between this and my other data tables?   If so, my main table has severa...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Create relationships with all the columns you need but make the inactive. Then use USERELATIONSHIP when you want to use them.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

If you want to use the calendar date to filter source data model, you have to create a relationship between them. For which date column should be linked to, it depends on your actual scenario. You should consider which date field the filter is applied to, which date field is referenced to in calculation.

 

Regards,

Yuliana Gu

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks but what if I want to filter on various columns?

     

    For example, I have an Actions table with expected completed, revised completed and actual completed dates. I need to filter on all 3 columns for different measures?

     

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous,

       

      Not very clear about your requirement. Please share some dummy data to illustrate your scenario. I need to know your expected output.

      How to Get Your Question Answered Quickly

       

      Regards,

      Yuliana Gu

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Yuliana,

         

        It's more of a abstract question about how to set up data models. I think I've figured it out anyway. Thanks.