Forum Discussion
Responsive ResidentEDATE but showing data until primary Date
Hi
Our PM needs to start working with the customer 4 month before Go Live date (GLD). I created a measure using the EDATE to show the date 4 months before the GLD
In the table it shows the month the PM needs to start working with the client but i would like to show same information until the GLD month.
Example: 380310CA01 in the table needs to show the PM is going to be busy in Feb, March, Apr and May...not only feb. Any tip? thanks
gg
3 Replies
- v-easonf-msft
Community Support
Hi, romovaro
Is GLD month fixed? It‘s not recommended to add 4 month offsets to date columns [ops forcast & Actuals]. You need a seperate calendar table in your model, then add new measures to recalculate the values of 'count of cuid', 'contract EE', 'Start value'. Please share sanitized sample data.
Best Regards,
Community Support Team _ Eason
romovaroYes, GLD should be fixed. Sometimes due to "issues" GLD can be moved but...
I added the new table with the measures. I would like to show every month that the person is working with the customer (4 months in advance) vs showing only the month of the "Go live date" - Ops Forecast and Actuals Column
https://www.dropbox.com/s/rzty7i3d78gm0bu/Capacity%20dashboard%20Test.pbix?dl=0
- romovaro
