How can I know the number of months we lost in terms of growth

[Andrew_na_lang]

Hi Fam,

I hope someone can help me. 

I calculated our running total and plotted it as a line chart. The line chart gave us a pretty nice idea of how the business accelerated over the years. In line with that projection, is there a way for me to know how many months we lost in terms of growth? 

The rolling total sales measure I used is: 

Running Total (Order Completed) =

CALCULATE(

[Number of Orders (Completed)],

FILTER(

ALL('Calendar'[Date]),

'Calendar'[Date] <= MAX('Calendar'[Date])

)

I heard about the what-if function. Is that how I should extract the information I need? 

Any help is much appreciated. 

Regards,

[v-chenwuz-msft]

Hi @Andrew_na_lang ,

How to use what-if function in power bi please refer this link.

Use what-if parameters to visualize variables - Power BI | Microsoft Docs

I think your first problem is how to calculate the trend line. Then subtract the current sales from the trend line. The trend line may be quadratic regression.

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.