Growth Trend

[nareshr89]

@tamerj1 @tamerI have 18 months data being loaded every month with the term Monthload. Each month load contains prior months actual and current & future months forecast values.

I have to obtain the growth trend.

Ex: CurrYear = 2022, MonthLoad = 5

Forecast(May to Dec, Jan_1 to June_1), Actuals(Jan to April)

Growth = Forecast(May to Oct i.e: 6 months) - Actuals(April) //Decides top growing & degrowing

Growth Trend = {Forecast(May) - Actual(April), Forecast(June) - Forecast(May), Forecast(July) - Forecast(June), Forecast(Aug) - Forecast(July), Forecast(Sept) - Forecast(Aug), Forecast(Oct) - Forecast(Sept)}

Trend = Forecast(May to Oct)

Forecast_May = Calculate(avg(ftes),year=2021,month_load=5, month=5)
Actual_April = Calculate(avg(ftes),year=2021,month_load=5,month=4)

[v-chenwuz-msft]

Hi @nareshr89 ,

What is the final result like? Not sure which one you need in the end. Please share some sample data and the corresponding results.

Or you can create a summarize table to get all avg of each month. You can refer my pbix file.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.