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

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.