Forum Discussion
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!
Hi Anonymous ,
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
5 Replies
ryan_mayuSuper User
Anonymous
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.
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%.
Hi Anonymous ,
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
Hi Anonymous ,
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