Solved: Headcount on a date filter

m1ke909 · ‎09-05-2019

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?

v-lili6-msft · ‎09-05-2019

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

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

View solution in original post

Ashish_Mathur · ‎09-05-2019

Hi,

Share some data and show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

v-lili6-msft · ‎09-05-2019

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

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

Headcount on a date filter

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

How to Get Your Question Answered Quickly

Be one of the first to start using Fabric Databases.