Forum Discussion
Calculating Percentage Active Over Time
Doing some analysis on remaining lifespan of components. I have an installation date, a retirement date, a calculated column determining if the component is active or retired, and a calculated age based on retirement date or today, depending on if active or retired. I'm trying to determine a cumulative percentage of components are still active at a given age. For example, if I have 100 components and 10 fail per year in the five years since installation, I'm currently showing 90% active for each year, instead of 50% active after year five.
1 Reply
- amitchandak
Super User
scharern , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
But seem like very similar to the problem discussed in my blog : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
See if the current employee calculation can help. Current vs installed till date
