Is it possible to do projections?

Anonymous · ‎05-19-2019

Hi folks,

I would like to know whether what I'm thinking of is possible and if yes, how you would go about it.

I have a file with employee records, including date of birth, gender, department, etc. In there I calculated the diversity (# of women / total number of employees) for each department as well as the whole organization.

I created another table that forecasts the year employees will retire by, based on their age and a slicer where we can select the estimated retirement age.

Is it at all possible, to calculate what the diversity will be if we were to replace all employees retiring this year by men, or only 90%, or 80%, etc? I'm probably dreaming but thought I'd ask 🙂

Thanks,

OF

parry2k · ‎05-19-2019

@Anonymous all this is achievable, Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.