Maintenance KPI - Planned Vs Actual Work Order Hours (Planner Accuracy) - Power BI Dashboard

[@demasjaring5435]

Awsome planning tool setup.

[@camo6244]

Fascinating, well paced, easy to follow & understand. Thank you very much.

[@rickeybrecheen4236]

Can you share the date table formula that you are using

[@rickeybrecheen4236]

How did you build your date table

[@BummerSlug]

That is pretty neat. Thank you for sharing.

[@rickeybrecheen4236]

I have closed work orders that have zero planned hours the I need to remove from the equation

[@Moonknight7777d9]

Hi Jason, Thanks for this one and wondering if you can you share the underlying excel sheet to have a better understanding :) much appreciated

[@jasondavidsondata]

Hi Freda, Sure, I've uploaded the source file to effectivedashboards.com/course/maintenance-kpi-planned-vs-actual-work-order-hours-planner-accuracy-power-bi-dashboard/
Cheers,
Jason

[@ColinMcGee-mz5xo]

How did you do the date's table?

[@jasondavidsondata]

Hi Colin, do you mean build the dates table?