Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
carlosdajer
Helper III
Helper III

Headcount Distribution - Changes by date

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.

 

2 REPLIES 2
amitchandak
Super User
Super User

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
Super User
Super User

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.