EXTRAPOLATE sum to next years

[Anonymous]

I Have a measure that says value X is:

Year       Value:
2021 = 10.000

2022 = 12.000

2023 = 14.000

Now I need to extrapolate this value to next years with an 10% decline, so for the 2021 years value for example:

2022 >> 10.000 * 0.1 = 1.000

2023 >> (10.000 - 1000) * 0.1 = 900

2024 >> (9000 - 900) * 0.1 = 810

Afterwards we have to do the same for the values of years 2022 and 2023

My start is to add this value to the datetable: 

Test =

VAR Yearsum = [ValueX]

VAR MyYear = MAX(DateTable[Year])

VAR TmpTable = SUMMARIZE(DateTable,DateTable[Year],"Value",Yearsum)

Bur hard to extrapolate the outcomes to the next years

[VahidDM]

Hi @Anonymous 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

[BeaBF]

@Anonymous  can you paste data on which calculate so?

Thx,

B.

[Anonymous]

The data is coming from a measure after adjusting a slicer, so this is a variable number per year. I am not allowed to share the data beacause it is organisational.