Forum Discussion
Asset Life Cycle Prediction Date
Hello!
I have a database with daily equipment operating time (uptime), and I'd like to preview when I achieve the lifecycle. I've read articles about linear regression, but I'm not finding the date I need.
My panel looks like this, and I want to have the date as shown on the card "Estimated Lifecycle Achievement". I'll filter an asset and see its KPIs. I have the lifecycle information, it's like 40,000 hours
Here is an real example of an equipment uptime registration.
| SiteId | Reading | MeterType | TakenDate | TakenBy | Uptime | AssetNumber |
| 055 | 22350,0 | HOURS | 2019-11-13 | IMPORT | 0,00 | LR12345 |
| 055 | 22359,5 | HOURS | 2019-11-14 | INTERPOLATE | 9,50 | LR12345 |
| 055 | 22369,0 | HOURS | 2019-11-15 | IMPORT | 9,50 | LR12345 |
| 055 | 22376,7 | HOURS | 2019-11-16 | INTERPOLATE | 7,67 | LR12345 |
| 055 | 22384,3 | HOURS | 2019-11-17 | INTERPOLATE | 7,67 | LR12345 |
| 055 | 22392,0 | HOURS | 2019-11-18 | IMPORT | 7,67 | LR12345 |
| 055 | 22408,0 | HOURS | 2019-11-19 | IMPORT | 16,00 | LR12345 |
| 055 | 22413,0 | HOURS | 2019-11-20 | IMPORT | 5,00 | LR12345 |
| 055 | 22434,0 | HOURS | 2019-11-21 | IMPORT | 21,00 | LR12345 |
| 055 | 22443,0 | HOURS | 2019-11-22 | IMPORT | 9,00 | LR12345 |
| 055 | 22445,0 | HOURS | 2019-11-23 | INTERPOLATE | 2,00 | LR12345 |
| 055 | 22447,0 | HOURS | 2019-11-24 | INTERPOLATE | 2,00 | LR12345 |
| 055 | 22449,0 | HOURS | 2019-11-25 | IMPORT | 2,00 | LR12345 |
| 055 | 22460,0 | HOURS | 2019-11-26 | IMPORT | 11,00 | LR12345 |
| 055 | 22475,0 | HOURS | 2019-11-27 | IMPORT | 15,00 | LR12345 |
| 055 | 22479,0 | HOURS | 2019-11-28 | INTERPOLATE | 4,00 | LR12345 |
| 055 | 22483,0 | HOURS | 2019-11-29 | INTERPOLATE | 4,00 | LR12345 |
| 055 | 22487,0 | HOURS | 2019-11-30 | INTERPOLATE | 4,00 | LR12345 |
| 055 | 22491,0 | HOURS | 2019-12-01 | INTERPOLATE | 4,00 | LR12345 |
2 Replies
v-xiaotangCommunity Support
Hi JOSEAFC
Thanks for reaching out to us.
Just want to confirm, is there a formula to calculate the Estimated Lifecycle Achievement, or do you want to know the principle of calculating it?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello!
I'd like some tips on building it. I'm new on Power BI and I'm suffering on advanced formulas.
