📔
TPW Staff Resources
  • About This Wiki
  • Staff Resources Read-Only
  • General
    • Acronym Lookup
    • Technology Service Requests
    • UKG Timesheets
  • Video, Chat, and Collaboration
    • Microsoft Teams
      • Creating Meetings
      • Joining Meetings
      • Chat
      • Creating Teams
      • Teams Channels
    • Miro
    • Using Box.com to Share Large Files
  • Working Remotely
    • Getting Started (revise this..)
    • Citrix Receiver
      • Connect from Outside the COA Network
      • Connect from Inside the COA Network
    • NetMotion
    • GoToMyPC
    • Working Remotely from a Mac
      • Troubleshooting AnyConnect for macOS Catalina
      • Resetting Your Network Password from a Mac
  • Computer Management
    • Managing your Network Password
    • ANTI-VIRUS for Computers not Connected to the City’s Network
  • Phone Resources
    • Checking Voicemail | Non-COA phone
    • Checking Voicemail | COA phones
    • Masking personal phone number when calling external numbers
    • Display your COA phone number when calling from your cell phone
    • Phone Forwarding (EC500)
    • Phone Forwarding Alternative (Avaya OneX Communicator)
    • Avaya IX Workplace Setup and User Guide for Mobile Phone
    • Voicemail to Email (Avaya Unified Messaging)
  • Power BI
    • Getting Started
    • How-To
      • Access Power BI Premium Workspace
      • Create a new premium workspace in Power BI
      • Connecting to a Dataflow
      • Access On-premise Data Gateway
      • Publish public link for Power BI item
    • Handover Checklist
      • SMD Signs and Markings Performance Measures
    • Power Query and DAX Formulas
      • Calendar Table
      • Calculate Fiscal Year
      • Conditional Format using DAX
      • Percent Complete on Time
  • Solutions Menu
    • Offerings
    • Do you know about MS Forms?
    • Need a Smart form for public intake?
    • What can SharePoint do?
    • So you need a dynamic Report & Dashboard?
    • What we can build in Knack
    • Need a custom solution?
Powered by GitBook
On this page

Was this helpful?

  1. Power BI
  2. Power Query and DAX Formulas

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)

PreviousConditional Format using DAXNextOfferings

Last updated 10 months ago

Was this helpful?