Exponential Growth Formula on Time Series Data

[alexcanton]

I'm looking for some support, Sorting rows of time series data by highest exponential growth. I am currently using =SLOPE in Excel but some trends have peaked and they still rank highly, so I'm trying to find a more nuanced approach. 

As an example of a data subset, the most recent fall of walmart in Jul21 falls almost half. I would rather inlcude rows at the top of my data that are consectively growing not growing over time then falling recently. 

Any suggestions for formula? I'm guessing it needs weighting added to recent months?

keyword

Slope

Sep 17

Oct 17

Nov 17

Dec 17

Jan 18

Feb 18

Mar 18

Apr 18

May 18

Jun 18

Jul 18

Aug 18

Sep 18

Oct 18

Nov 18

Dec 18

Jan 19

Feb 19

Mar 19

Apr 19

May 19

Jun 19

Jul 19

Aug 19

Sep 19

Oct 19

Nov 19

Dec 19

Jan 20

Feb 20

Mar 20

Apr 20

May 20

Jun 20

Jul 20

Aug 20

Sep 20

Oct 20

Nov 20

Dec 20

Jan 21

Feb 21

Mar 21

Apr 21

May 21

Jun 21

Jul 21

Aug 21

walmart

27051

37M

30M

37M

56M

56M

30M

30M

37M

30M

37M

37M

37M

37M

37M

37M

56M

56M

37M

37M

37M

37M

37M

37M

46M

37M

37M

37M

56M

56M

37M

30M

56M

83M

83M

68M

68M

68M

56M

56M

101M

83M

56M

46M

56M

56M

101M

56M

68M

https://docs.google.com/spreadsheets/d/12I9JQe313NepHjkn28VRWOjJNs9KJELiFwUZNjwLlhs/edit?usp=sharing 

[alexcanton]

As an example of a data subset, the most recent fall of walmart in Jul21 falls almost half. I would rather inlcude rows at the top of my data that are consectively growing not growing over time then falling recently. 

Any suggestions for formula? I'm guessing it needs weighting added to recent months?

keyword

Slope

Sep 17

Oct 17

Nov 17

Dec 17

Jan 18

Feb 18

Mar 18

Apr 18

May 18

Jun 18

Jul 18

Aug 18

Sep 18

Oct 18

Nov 18

Dec 18

Jan 19

Feb 19

Mar 19

Apr 19

May 19

Jun 19

Jul 19

Aug 19

Sep 19

Oct 19

Nov 19

Dec 19

Jan 20

Feb 20

Mar 20

Apr 20

May 20

Jun 20

Jul 20

Aug 20

Sep 20

Oct 20

Nov 20

Dec 20

Jan 21

Feb 21

Mar 21

Apr 21

May 21

Jun 21

Jul 21

Aug 21

walmart

27051

37M

30M

37M

56M

56M

30M

30M

37M

30M

37M

37M

37M

37M

37M

37M

56M

56M

37M

37M

37M

37M

37M

37M

46M

37M

37M

37M

56M

56M

37M

30M

56M

83M

83M

68M

68M

68M

56M

56M

101M

83M

56M

46M

56M

56M

101M

56M

68M

https://docs.google.com/spreadsheets/d/12I9JQe313NepHjkn28VRWOjJNs9KJELiFwUZNjwLlhs/edit?usp=sharing 

[VahidDM]

As @Anonymous mentioned here, update your request and add a sample of the result you are looking for to the post.

Appreciate your Kudos✌️!!

[Anonymous]

Most likely you don't get any replies because people don't understand your issue. Please rephrase.

How to Get Your Question Answered Quickly - Microsoft Power BI Community