Count the number of Employees that started each month

[AnnaKi]

Hi!

I have an "Interval" table between my Date table (DimDate) and my Transactions table.

Each Employee has a DateKey consisting of (Start Date)|(End Date) =  SDate|EDate. Each DateKey has Dates from the SDate to the EDate in the DimDate table.

I want to count the number of EmployeeKeys that have started in each period. So where the "SDate" for an EmployeeKey in the Transactions table is the same as the "Date" in the DimDate table, then the count is one for that period only for that EmployeeKey.

What I am after is the following:

Any ideas?

[v-chenwuz-msft]

Hi @AnnaKi ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards

Community Support Team _ chenwu zhu

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

[AnnaKi · Accepted solution]

I got help from a colleage:

Starters =

VAR selectedDate = MAX('DimDate'[Date])

RETURN

CALCULATE(DISTINCTCOUNT(Employee[EmployeeNo]), Employee[StarterDate] = selectedDate)