Asset Life Cycle Prediction Date

[JOSEAFC]

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

[v-xiaotang]

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.

[JOSEAFC]

Hello!

I'd like some tips on building it. I'm new on Power BI and I'm suffering on advanced formulas.