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

Andrew_na_lang — Wed, 08 Jun 2022 13:56:07 GMT

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,

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

v-chenwuz-msft — Mon, 13 Jun 2022 06:19:08 GMT

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.

topic How can I know the number of months we lost in terms of growth in DAX Commands and Tips

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

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