Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I would like to calculate the percentage growth of the population from 2011-2020 for each age-group.
I created the following calculated table:
Now i would like to have a extra column with the %-growth for each age-group.
I'd appreciate any help.
Solved! Go to Solution.
Hi, @Anonymous
I am not sure if I understood your question correctly.
I created a simplified version of your sample.
Please check the below picture and the sample pbix file's link down below.
It is for creating a new column. The formula is for finding the growth percentage that compares to the previous year. In this case, the previous year of 2020 in the table is 2011.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
I am not sure if I understood your question correctly.
I created a simplified version of your sample.
Please check the below picture and the sample pbix file's link down below.
It is for creating a new column. The formula is for finding the growth percentage that compares to the previous year. In this case, the previous year of 2020 in the table is 2011.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
The best way to do it is using time intelligence functions but for time intelligence functions to work, you need to edit your model a bit. You need to create a data table, update the dates in your existing table and relate the dates table with your existing table. Then you can use the PARALLELPERIOD to jump 9 years back. A similar example is shown on https://www.mssqltips.com/sqlservertip/6424/calculate-percentage-growth-over-time-with-power-bi/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |