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!

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

      I think that the issue here is that you have jumped forward to what you believe to be the solution to your problem and asking how to do it without any of the background information required rather than presenting some sample raw data, relationships, etc. and then explaining what you are trying to accomplish. See:

       

      https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

       

      I'm not clear on the need for separate calendar tables and have a hard time believing that is really the solution but I do not know enough about the source data, real issue or the extra things you are trying to calculate, etc. to really be of any help.