🔢 4. DAX Measures & KPI

I created custom calculated columns and DAX measures in Power BI to analyze hospital performance and patient care metrics.

⏱️ Waiting Status

Waiting Status = IF('Hospital ER_Data'[Patient Wait time]<=30, "Within Target", "Target Missed")

➝ Categorizes patients as On Target (≤30 min) or Delayed (>30 min).

📊 Wait Time Interval

Wait time Interval = SWITCH( TRUE(), 'Hospital ER_Data'[Admission Hour]<=2,"00-02",
 'Hospital ER_Data'[Admission Hour]<=4,"03-04", 
 'Hospital ER_Data'[Admission Hour]<=6,"05-06",
  'Hospital ER_Data'[Admission Hour]<=8,"07-08",
   'Hospital ER_Data'[Admission Hour]<=10,"09-10",
    'Hospital ER_Data'[Admission Hour]<=12,"11-12",
     'Hospital ER_Data'[Admission Hour]<=14,"13-14",
      'Hospital ER_Data'[Admission Hour]<=16,"15-16",
      'Hospital ER_Data'[Admission Hour]<=18,"17-18",
      'Hospital ER_Data'[Admission Hour]<=20,"19-20",
      'Hospital ER_Data'[Admission Hour]<=22,"21-22",
      'Hospital ER_Data'[Admission Hour]<=24,"23-24", "Above 24")

➝ Groups patients into time buckets for wait time analysis.

📅 Patients by Admin Date

Patients Admin Date = DATE(YEAR('Hospital ER_Data'[Patient Admission Date]),MONTH('Hospital ER_Data'[Patient Admission Date]),DAY('Hospital ER_Data'[Patient Admission Date]))

➝ Tracks patient inflow daily, weekly, and monthly based on admission date

🏷️ No. of Patients Referred

No of Patients Referred = CALCULATE(COUNTROWS('Hospital ER_Data'), 'Hospital ER_Data'[Department Referral] <> "None")

➝ Measures the number of referrals from departments (e.g., General Practice, Orthopedics).

⏳ Average Wait Time

Avg Wait Time = FORMAT(AVERAGE('Hospital ER_Data'[Patient Waittime]),"0.0") & " " & "Min”

➝ Displays the mean waiting time across all patients.

⭐ Avg Satisfaction Score

Satisfaction Score = AVERAGE('Hospital ER_Data'[Patient Satisfaction Score])