Headcount Calculation (Monthwise, quarterwise, yearwise)

Hi Anonymous ,

Thank you for ExcelMonke answer , and I have other suggestions:

Below is my table:

It has employee columns, start date and end date and status columns for active or inactive.

The following DAX might work for you:

Measure = 
  CALCULATE(COUNT('Table'[Customer]),FILTER('Table','Table'[Flag] = "active"))

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.