Calendar for each ID field?

Question

Hi everyone!&nbsp;I need to create some kind of dinamically calendar. What do I mean? I have a dimension table (with project IDs), where&nbsp;each project have a start and end date. So, I need to have one calendar per project, each one starting and ending in the defined date. This is because in each calendar I'll have to calculate the progress based in the points that each project have.&nbsp;So, I was wondering about how to implement this solution in the best performance way possible. Any ideas?&nbsp;Thankss!!

v-huizhn-msft · Answer

Hi&nbsp;Anonymous,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

greg_deckler · Answer

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:&nbsp;https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490&nbsp;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.

greg_deckler · Answer

CALENDAR function will do this.&nbsp;https://msdn.microsoft.com/en-us/library/dn802546.aspx&nbsp;

anonymous · Answer

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.

anonymous · Answer

Yes, I have a table with start and end date for each project. I was thinking about create a calendar like this:&nbsp;ProjectID &nbsp; &nbsp; dateP1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;startDateP1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;startDate + 1P1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...P1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;endDateP2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;startDateP2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;startDate + 1P2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...P2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;endDate&nbsp;Any ideas of how I could achieve it?&nbsp;Thanks!

Forum Discussion

Calendar for each ID field?

5 Replies

Related content

Calendar Slicer with Different Business Calendars

Tweaking Financial Calendar

Master calendar to generate fields

Custom calendar

Weeknum as per Calendar