Find growth between two periods

[rulefox13]

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

[v-jayw-msft]

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

[rulefox13]

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

[v-jayw-msft · 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]

Best Regards,

Jay

[ryan_mayu]

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

[rulefox13]

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