EDATE but showing data until primary Date

[romovaro]

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

[v-easonf-msft]

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

[romovaro]

Yes, 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]

Hi v-easonf-msft

Were you able to open the file? any idea how to continue? thanks