Forum Discussion
Hospital Bed Occupancy by Unit Calculation
I am looking for help on creating a dashboard on Hospital Bed Occupancy however, the number of funded hospital beds changes periodically and our occupancy is calculated by patient days (length of patient stay)/bed days. Bed Days calculation is your date_day sum/sum of funded beds
Our "# of funded Beds" changed/changes and we currently use an excel spreadsheet in the dashboard to link our patient days to our number of funded beds (see example below for a break down of # of funded beds) based on "Hospital Unit" and "Beds".
Is there a way to have the changing number of beds calculate into the occupancy if it changes in the Power BI Dashboard?
| Unit | Beds |
| 3-5/3-8 CCU | 12 |
| 3-7 ICU | 8 |
| 3-1 Woman & Child | 16 |
| 6-1/6-2 Medicine | 34 |
| 4-1 RSU/Surgery | 28 |
| L & D | 0 |
| 4-4 PICU | 7 |
| 4-5 MH | 22 |
| 4-6 MH | 16 |
| 8-1 Rehab | 16 |
| 3-2 NB Bassinetes | 16 |
| 8-1 CCC | 0 |
| 2-4 ED | 0 |
| 8-1 Medicine | 0 |
| ER Inpatient | 0 |
| ER Inpatient-WI | 0 |
| ER Inpatient-MA | 0 |
| TCU | 16 |
| ER Inpatient-ME | 0 |
2 Replies
Anonymous
what's the expected output based on the sample data you provided?
Hi Anonymous
Please provide sample data that fully covers your problem and describe the expected result, if possible it is best to share your pbix file (remove sensitive data).
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
