Forum Discussion
Solved
Comparing Volume by Dates
I need to develop a visual to show the number of patients admitted compared to the number of patients discharged by month, year. I have the admission and discharge dates in the same table, and curre...
Hi,
Create a non-active relationship (Many to One and Single) from the Admission date to the Date column of the Calendar Table. To your visual, drag Year and Month name from the Calendar Table. Write these measures
Discharged = distinctcount(Data[Patient ID])
Admitted = calculate([discharged],userelationship(Data[Admission date],Calendar[date]))
Hope this helps.
I got it. Needed to remove [Date] from the compelte date.
Thank you!
I got it. Needed to remove [Date] from the compelte date.
Thank you!
You are welcome.