Forum Discussion
Solved
Growth Rate Measure that SUMS Growth Rate Column instead of calculating Total Row
Hi, I am new to Power BI and DAX. I am trying to calculate a simple 3-year growth rate like this example from excel: Age 2018 2019 2020 Growth Rate <= 20 6 3 4 -33.33% 21-25 7 1...
Hi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Growth Rate: =DIVIDE ( SUM ( Data[2020] ) - SUM ( Data[2018] ), SUM ( Data[2018] ) )
Jihwan_Kim
Super User
Super UserHi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Growth Rate: =
DIVIDE ( SUM ( Data[2020] ) - SUM ( Data[2018] ), SUM ( Data[2018] ) )
