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...
Hello there,
It sounds like you're working on a data analysis project involving inmate counts from booking and release dates, and you're encountering some discrepancies in your results. It's possible that the issue lies in the relationship between your 'Date' table and the 'vwBookingSearch' table, especially considering multiple years of data. The Max('Date'[Date]) function might indeed be affecting the output, so exploring alternative approaches or refining your DAX code could be beneficial. Additionally, ensuring a proper relationship between your tables could help resolve the discrepancy. Having accurate data is crucial, just like having a reliable mugshot to identify individuals accurately.