Forum Discussion
Cumulative Distinct Employee Count with Multiple Filters
Here is one possible implementation. It uses a disconnected calendar table.
What does "active" mean in your context? Termination date is null or in the future?
Please provide sanitized sample data that fully covers your issue. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Active would employees that are not terminated and hired before a month. The key issue is that the graph is supposed to be rolling twelve months but I have many employees hired years ago. Thanks
Employee Contract Hire Date Termination Date Cost Center Unique ID Bob A 4/1/2020 Test Bob-A Tom B 7/1/2021 6/1/2022 One Tom-B John C 12/1/2021 JW John-C Mary A 5/1/2016 HP Mary -A Steve C 1/1/2022 4/1/2022 SDS Steve-C Here is one possible implementation. It uses a disconnected calendar table.