Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alexcanton
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
walmart2705137M30M37M56M56M30M30M37M30M37M37M37M37M37M37M56M56M37M37M37M37M37M37M46M37M37M37M56M56M37M30M56M83M83M68M68M68M56M56M101M83M56M46M56M56M101M56M68M

 

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

2 REPLIES 2
VahidDM
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✌️!!

Anonymous
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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.