Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.