Forum Discussion
Simulate values one year forwards
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)
3 Replies
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.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?
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
