Forum Discussion
Solved
Help Building Deadlines for Single Items with Multiple IDs
Hi everyone - long question here - I am trying to build KPIs for my team but running into some issues with the way our data is managed. Long story short - I need to measure our performance servi...
Hi quincy_p,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
quincy_p , Try these in power query - Contract Table
// Add Cycle list column (list of deadlines)
#"Add Cycles" =
Table.AddColumn(
#"Expanded MaxRow",
"Cycles",
each
let
Start = [Original_Start_Date],
End = [Final_End_Date],
Freq = [Contract_PM_Frequency],
Deadlines =
List.Generate(
()=> Start,
each _ <= End,
each Date.AddMonths(_, Freq)
)
in Deadlines
),
// Expand into rows
#"Expand Cycles" =
Table.ExpandListColumn(#"Add Cycles", "Cycles")
new cycle no in work order
CycleNumber =
Number.RoundUp(
Duration.Days([Actual_Resolution_Date] - ContractStartDate)
/ (FreqMonths * 30.4375)
)
quincy_p , and these measures , if they can help
haswo =
if(countrows(relatedtable(workorders)) > 0, 1, 0)
OnTime =
var wodate = calculate( min(workorders[actual_resolution_date]) )
var deadline = selectedvalue(contractdeadlines[deadline])
return
if(isblank(wodate), "missed", if(wodate <= deadline, "on time", "late") )