All, I'm not sure if this is the correct place to ask this question but I'm looking for help on creating a hospital census dashboard. I want to use a matrix visualization to show which patients were present at a particular hospital on a given date. Sample data set Patient A admitted on 1/1/2021 and discharged on 1/2/2021Patient B admitted on 1/1/2021 and discharged on 1/3/2021Patient C admitted on 1/2/2021 and discharged on 1/3/2021Patient D admitted on 1/2/2021 and discharged on 1/5/2021Patient E admitted on 1/3/2021 and discharged on 1/4/2021 The matrix visualization should then display Date1/1/2021 Patient A Patient B1/2/2021 Patient A Patient B Patient C Patient D1/3/2021 Patient B Patient C Patient D Patient E1/4/2021 Patient D Patient E1/5/2021 Patient D1/6/2021 No Patients I can't figure out how to include a patient visit if the date being evaluated falls between the admit and discharge dates for that visit. Can anyone help me figure this out?Thank you,Ron

Hi ErDrRon , 1.When you import the data into Power BI, it looks like this in the Power Query Editor. 2.Right-click the field name and select Split by positions. 3.It will intelligently figure out where you want to split, we remove the 8 and click ok. 3.Remove unnecessary columns and rename other columns. Click Close&Apply. 4.Create a calendar table. No relationships between tables. Table 2 = CALENDAR(DATE(2021,1,1),DATE(2021,1,10)) 5.Create the measure and put into the matrix. Measure = IF( MAX('Table'[Admitted Date]) <= MAX ( 'Table 2'[Date] ) && MAX('Table'[Discharged Date]) >= MAX ( 'Table 2'[Date] ) ,"In Hospital" ) Best Regards, Stephen Tao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Creating a hospital census dashboard | Microsoft Fabric Community

Forum Discussion

Related content

Hospital Emergency Room| Dashboard

Creating a Dashboard for operations

Hospital Patient Flow Dashboard

Hospital Emergency Room | Dashboard

How to create a beautiful Power BI Dashboard/Report?