Forum Discussion

pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate I
8 years ago

Calendar for each ID field?

Hi everyone!   I need to create some kind of dinamically calendar. What do I mean? I have a dimension table (with project IDs), where each project have a start and end date. So, I need to have one ...
Need Help
  • pollyog's avatar
    pollyog
    Icon for Advocate I rankAdvocate I
    8 years ago

    Hi Smoupre, thanks. But I think I didn't explain it good. O know the calendar function, that I cand use a start and end date to create the table values. The question is, I need to have one calendar for each project ID in my Project table because for each project I will have to calculate some other information in the calendar table. But I would like to do it in a good performance way.

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

      Hi pollyog,

      Based on my understanding, each project in your table have a start and end date, you will create a canlendar table based on each project's start and end date, right? If it is, you will create many canlendar tables because there are many projects, and every calendar is different. There is no better way to create mutiple table at once, you have to create them one by one.

      Best Regards,
      Angelia

      • pollyog's avatar
        pollyog
        Icon for Advocate I rankAdvocate I
        8 years ago

        Yes, I have a table with start and end date for each project. I was thinking about create a calendar like this:

         

        ProjectID     date

        P1                startDate

        P1                startDate + 1

        P1                ...

        P1                endDate

        P2                startDate

        P2                startDate + 1

        P2                ...

        P2                endDate

         

        Any ideas of how I could achieve it?

         

        Thanks!