Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello everyone.
I need to calculate the occupancy rate of the beds through a data segmentation filter by period or date.
I have as parameter, the date of entry and the date of departure of each patient, the total number of beds and patients who do not have date of exit because they are still hospitalized("AQ8730").
As you can see, in the photo below:
As of October 1, we had 16 new patients.
On October 2 we had more patients coming in and others still hospitalized.
If we look only at the date of the first day of October, we had only 5 patients hospitalized. (not counting those who were already admitted before this date, as you can see the patient on September 30 in line "C8712" photo.)
Just do not have the slightest idea to apply that to powerbi.
Thank you very much for your attention!
I would appreciate it if anyone could help me!
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Hello Greg,
Sorry for my ignorance.
I could not understand these two links to my reality.
User | Count |
---|---|
90 | |
88 | |
88 | |
79 | |
49 |
User | Count |
---|---|
153 | |
145 | |
106 | |
74 | |
55 |