Simulate values one year forwards

[Anonymous]

Hello community!

I am new to PBI and am tying to "simulate" a value one year in the future from the last record avalilable. In this particular case the future salary of employees.

• I have calculated the average yearly increase in salary, based on historical data for that employee (X%)
• I have then managed to display a date one year ahead from the last available record

Simulated date = EDATE(MAX('Table' [Date]),12)

However - I am not able to display this information togeter with the existing salary records.

The output i would like is:

Anyone who can help with this?

br

Alex

[amitchandak]

@Anonymous , Assume you have two measure

[historical] and [simulated] and there are joined common date table/dimension. Then you should be able to put them together.

Can you share sample data and sample output in table format?

[Anonymous]

Thanks for the reply!

Input data as follows:

Name	Salary	From Date
John	22567	2017-06-01
John	23692	2018-01-01
John	24119	2018-06-01
John	24626	2019-06-01
Bill	31250	2017-06-01
Bill	32250	2018-01-01
Bill	32950	2018-06-01
Bill	33900	2019-07-01

Desired output:

Name	Simulated future salary	from date
John	24626 * increase	2020-06-01
Bill	33900 * increase	2020-07-01

Then display the data as shown above

br

Alex

[Greg_Deckler]

@Anonymous - A little hard to follow but seems like you need a measure that displays someone's salary if historical and their calculated salary if in the future. But, hard to be more specific with the information provided.

Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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.