Headcount on a date filter

[m1ke909]

Morning all!

I'm really stuck on this one so any help would be amazing!

I'm looking at a list of employees with various start and end dates over a rolling 12 months. 

The employee data has anyone who started prior to the 12 months and anyone who ended from 12 months ago up until today. 

What I'm trying to do is filter to any date in the past 12 months and see the head count at that date. 

Is this possible? 

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[v-lili6-msft · Accepted solution]

hi, @m1ke909 

Yes, you could get it. here is the similar post, you could refer to it:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

Best Regards,

Lin