Forum Discussion
Distribute Values on Months between 2 Dates (Data Attached)
Anonymous
Good morning,
have you ever found a solution to this problem? I am currently struggling with the same problem. I only have one row for each item ID. When I try to distribute the item value across the data, the distribution only occurs within the measure. Of course, if I select a random month where the item ID is not present (for example, a date within the start and end dates), the item disappears because the realtion model does not recognize the selected month for the specific item.
Hi,
Yes, it has been quite a while - so I am not into the context anymore. I managed to solve it and I'm just going to have to paste the solution to you - basciallyI had to create a date calendar (I probably could have used my existing datekey calendar, but I didn't know better at the time) like so:
Resource Calendar = FILTER(CALENDAR("2016-01-01","2024-12-31"),DAY([Date])=1)And then crossjoin with my original table above:
Resource Distribution = FILTER(CROSSJOIN('Resources','Resource Calendar'),'Resource Calendar'[Date]>='Resources'[ImplementationLevel(IL3).ExpectedProgress]&&'Resource Calendar'[Date]<='Resources'[ImplementationLevel(IL4).ExpectedProgress])
Giving me a row by row distribution of the resources, my description might not be exactly accurate but it's just from glancing over a project from 4 years ago, so you might have to just go by the DAX.