Forum Discussion
HR Employee Headcount Matrix
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 a...
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.