Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am trying to forcast when an employee will retire.
Our employees usually retire with 30 years of service and are between 50 and 55. I have the data for years of service and date of birth. I am not sure how I would write the formula.
I want to show a range.
25 years of service at age 50
26 years of service at age 51
etc.
Can anyone help me with the formula? I was thinking a if and then statement but I'm note sure.
Solved! Go to Solution.
Hi @4mkurtz71 ,
Is this the expected output you want? Please check the pbix file.
If not, please consider posting more details and expected output. Thanks.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Hello @4mkurtz71
can you please share a visual representation of what you would like to achieve ?
best regards,
Now | age 55 & 30 years of service |
in 1 year | age 55 & 30 years of service |
in 2 years | age 55 & 30 years of service |
in 3 years | age 55 & 30 years of service |
in 4 years | age 55 & 30 years of service |
in 5 years | age 55 & 30 years of service |
The data I have is below. I am trying to forecast expected retirements. Most employees will retire at 30 years of service and age 55. I would like to forecast for the next 5 years.
How many employees are 50 and have 25 years of service
51 and 26 years of service
52 and 27 years of service
53 and 28 years of service
54 and 29 years of service
55 and 30 years of service
I want to slice it out in rank as well.
Thank you for any help you can provide.
EmplID | Name | Job Code | Job Title | Union Code | Birthdate | Age | Years of Service | Years till Age 55 & 30 Years Service |
Hi @4mkurtz71 ,
Is this the expected output you want? Please check the pbix file.
If not, please consider posting more details and expected output. Thanks.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |