I'm trying to create a matrix that allows me to display the start of month (SOM) and end of month (EOM) employee headcounts by month and by driver type or by terminal. The formulas I currently have are correct for the totals, but do not work in the matrix (i.e. cannot be filtered by the driver type or terminal). I've included a screenshot of the matrix and the DAX formulas for the current SOM and EOM headcounts. How do I write this so that they are filtereable in the matrices by terminal or driver type? Everything I've tried does not give correct counts.
@AmandaMulryan , Use Min and Max on date of date column, in formula used in blog
Or refer file attached. Use Min/Max for start and end of month on date of date table in measure
I have that already written out in the formulas I listed. The formulas I listed are correct with the totals. However, as seen in the screenshot, they do not calculate correctly BY driver type or BY terminal, as well as per month. I am looking to get the total SOM and EOM counts per month, PER Terminal or PER driver type. They will only give me the overall total.
User | Count |
---|---|
212 | |
80 | |
79 | |
77 | |
50 |
User | Count |
---|---|
173 | |
92 | |
85 | |
79 | |
70 |