DAX to Get a Treatment Team Patient Census for a Point in time
Hello PowerBI fam, I am spinning my wheels trying to get a census for patients assigned to a treatment team. I want to know how many patients were the treatment team assigned to at 12:00 pm and 11:59 pm. Basically a census count at noon and before midnight. Here is my example data for one patient. So for the patient above , on 08/01/2023, they would be counted at 12:00 pm census for treatment team GRADY ACS TRAUMA 1. Also, for the 11:50 pm (on 08/01/2023) census is SURGICAL INTENSIVE CARE J. The patient can be assigned to multiple treatment teams during their stay. Any help will be greatly appreciated.
