Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I want to find the absolute and % growth over 2015-2020 using my total sales data. What command should I use? Much appreciated!
Solved! Go to 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
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
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]
Best Regards,
Jay
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.
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%.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |