Plotting a forecast based on single year data and given percentage of decrease

[Anonymous]

Hi everyone, I have data of one year and I want to plot a graph with a % of decrease based on the total of the year.
For example, 

2023= 100
2024 = 2023 - (2023 * 4.2%)
2025 = 2024 - (2023 * 4.2%)
2026 = 2025 - (2023 * 4.2%)
...
2050 = 2049 - (2023 *4.2%)

I have the value of 2023. I have done it manually on excel however I would like to do it natively on Power BI. Woud love any and all help!

[lbendlin · Accepted solution]

see attached