Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Exponential Growth Formula on Time Series Data



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?


keywordSlopeSep 17Oct 17Nov 17Dec 17Jan 18Feb 18Mar 18Apr 18May 18Jun 18Jul 18Aug 18Sep 18Oct 18Nov 18Dec 18Jan 19Feb 19Mar 19Apr 19May 19Jun 19Jul 19Aug 19Sep 19Oct 19Nov 19Dec 19Jan 20Feb 20Mar 20Apr 20May 20Jun 20Jul 20Aug 20Sep 20Oct 20Nov 20Dec 20Jan 21Feb 21Mar 21Apr 21May 21Jun 21Jul 21Aug 21

Super User
Super User

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



Appreciate your Kudos✌️!!

Not applicable

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


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors