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...
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.