Headcount Distribution - Changes by date

[carlosdajer]

I have a team of 30 employees divided by 3 supervisors. For their KPI scores, I would like to build a headcount distribution where I can change the supervisor but the data from the past remains with the previous supervisor. I don't have any idea how to create a table that I can change the values if needed.

The idea is to create a relationship in DImdate so when I change dates or Filter by Supervisor, the agent that now belongs to the sup will show up depending on the date.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Refer, if this can help : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Appreciate your Kudos.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490