Population Percentage Increase Year On Year

[tb92]

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

[DataInsights · Accepted solution]

@tb92,

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

[tb92]

Worked perfectly, thank you! 😀