Modified Census Count By Month using Admit/Discharge Dates

[AFultz]

Hello,

I need to be able to show on a graph how many Cases an agency program has maintained each month. It is essentially a census count for the month, but I'm only supposed to include cases that have been in program for every day in the month. Anyone who has been admitted or discharged partway through the month needs to be excluded from that month's count. 

I have an Enrollment Report that lists each Case with an admit date and discharge date in the same row. Is there a Measure that would be able to accomplish this? Or another route?

Any guidance on this would be greatly appreciated! 

[amitchandak]

@AFultz , Based on what I got, You need a common date table and join with both date columns. And inactive join you can activate using use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...