topic Re: Calculating Percentage Active Over Time in DAX Commands and Tips

Calculating Percentage Active Over Time

scharern — Wed, 16 Sep 2020 19:34:07 GMT

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.

Re: Calculating Percentage Active Over Time

amitchandak — Thu, 17 Sep 2020 00:59:10 GMT

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