cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rulefox13
Regular Visitor

Find growth between two periods

Hello, I want to find the absolute and % growth over 2015-2020 using my total sales data. What command should I use? Much appreciated! 

 
 
 

for Powerbi community.JPG

 

 

1 ACCEPTED SOLUTION

Hi @rulefox13 ,

 

You could use Min() and Max() function.

Check the measures below.

start = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Year]=MIN(dates[year])))

end = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Year]=max(dates[year])))

Measure = ([end]-[start])/[start]

1.PNG2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

5 REPLIES 5
v-jayw-msft
Community Support
Community Support

Hi @rulefox13 ,

 

I'm not sure what you mean two periods. You want compare sales over 2015-2020 to total sales?

Please show some sample data and expected result to us.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi Jay,

 

I am trying to find the growth rate between to year periods. e.g. 

 

Year   Sales

2015  100

2016  150

2017  180

2018  220

2019  250

2020  290

 

I want to find out how to calculate the growth rate between 2015-2020 (Sales growth between between 100 and 290). The answer should be 190%. 

Hi @rulefox13 ,

 

You could use Min() and Max() function.

Check the measures below.

start = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Year]=MIN(dates[year])))

end = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Year]=max(dates[year])))

Measure = ([end]-[start])/[start]

1.PNG2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

ryan_mayu
Super User II
Super User II

@rulefox13 

If you don't have a date column in sales table , you can create it and build the relationship with date's date column.

please see the attachment . hope this is helpful.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi, thanks for your reply. However, you seem to have provided year over year growth. I am looking for growth between two years. For example,

 

Year   Sales

2015  100

2016  150

2017  180

2018  220

2019  250

2020  290

 

I want to find out how to calculate the growth rate between 2015-2020 (sales growth between between 100 and 290). The answer should be 190%. 

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.