Forum Discussion
Calendar for each ID field?
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.
Microsoft EmployeeHi 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
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
Community Champion
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.
