Calculating Percentage Active Over Time

[scharern]

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.

[amitchandak]

@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-tr...

See if the current employee calculation can help. Current vs installed till date