Percent Complete on Time
This is the formula used to calculate Percent Complete on Time for '311 TPW CSRs' dataflow in Power BI
Percent Complete on Time =
VAR onTimeCSRs = SUM('311 TPW CSRs'[Closed on Time])
VAR totalCSRs = onTimeCSRs + SUM('311 TPW CSRs'[Closed Late])
RETURN
DIVIDE(onTimeCSRs,totalCSRs)
Last updated
Was this helpful?