cancel
Showing results for
Did you mean:
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!

1 ACCEPTED SOLUTION
Community Support

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]``````

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.
5 REPLIES 5
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.

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.
Regular Visitor

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%.

Community Support

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]``````

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.
Super User II

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

Proud to be a Super User!

Regular Visitor

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%.

Announcements