Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
4mkurtz71
New Member

New User need help with formula

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.

1 ACCEPTED SOLUTION

Hi @4mkurtz71 ,

Is this the expected output you want? Please check the pbix file.

vcgaomsft_1-1706509410686.png

vcgaomsft_2-1706509985581.png

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

View solution in original post

4 REPLIES 4
Daniel29195
Super User
Super User

Hello @4mkurtz71 

 

can you please share a visual representation of what you would like to achieve ? 

 

 

best regards,

Nowage 55 & 30 years of service
in 1 yearage 55 & 30 years of service
in 2 yearsage 55 & 30 years of service
in 3 yearsage 55 & 30 years of service
in 4 yearsage 55 & 30 years of service
in 5 yearsage 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.

 

 

EmplIDNameJob CodeJob TitleUnion CodeBirthdateAgeYears of ServiceYears till Age 55 & 30 Years Service

Hi @4mkurtz71 ,

Is this the expected output you want? Please check the pbix file.

vcgaomsft_1-1706509410686.png

vcgaomsft_2-1706509985581.png

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.