Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I have the following data set for population percentage increase (Year on Year);
Year | Percentage Growth |
2023 | 0.81% |
2024 | 0.77% |
2025 | 0.68% |
With a starting population in 2022 of 1000, how do I acheive the desired outcome ? :
Initial Value (2022) | 1000 | |
Year | Percentage Growth | Result |
2023 | 0.81% | 1008.1 |
2024 | 0.77% | 1015.862 |
2025 | 0.68% | 1022.77 |
Where the population is increasing by a given percentage each year (based on the previous years value)?
Thanks
Solved! Go to Solution.
Try this measure:
Calculated Population =
VAR vStartingPopulation = 1000
VAR vCurrentYear =
MAX ( Population[Year] )
VAR vResult =
vStartingPopulation
* PRODUCTX (
FILTER ( ALLSELECTED ( Population ), Population[Year] <= vCurrentYear ),
1 + Population[Percentage Growth]
)
RETURN
vResult
Proud to be a Super User!
Try this measure:
Calculated Population =
VAR vStartingPopulation = 1000
VAR vCurrentYear =
MAX ( Population[Year] )
VAR vResult =
vStartingPopulation
* PRODUCTX (
FILTER ( ALLSELECTED ( Population ), Population[Year] <= vCurrentYear ),
1 + Population[Percentage Growth]
)
RETURN
vResult
Proud to be a Super User!
Worked perfectly, thank you! 😀