Forum Discussion
Monthly Inmate Count From Booking and Release date
Hello all, I have the booking and release date for inmates in a Jail. I would like to have the count of inmates in jail per month. I have tried the following DAX code: InmateCount = VAR s...
Thank you. The HR problem is similar but also gives very low answers. I know from the data source that the inmates get booked into that the inmate count is nearly 70 every month. Here Is what I get with both of these attempts:
This is identical for what I tried the first time and the second. My data looks the same as the HR example.
I can tell it has something to do with the date relationship because if I break it down by year this is what I get a smaller number then all the months combined for 2022.
I fixed this by duplicating the table and deleting all other relationships from it.