Calendar for each ID field?

[pollyog]

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 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.

So, I was wondering about how to implement this solution in the best performance way possible. Any ideas?

Thankss!!

[Greg_Deckler]

CALENDAR function will do this.

https://msdn.microsoft.com/en-us/library/dn802546.aspx

[pollyog]

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]

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]

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]

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.