Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |