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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JoseHop
Helper I
Helper I

Count of employes per year

hi There, 

 

I have a list of employes with a function, start date and an end date: 

Pete01-01-201831-12-2055

sales

Maria12-03-201931-12-2055after sales
Sharon01-01-201831-12-2020sales
Mike15-04-202031-12-2021after sales

 

I'm looking for the answer: 

 20182019202020212022
sales22211
after sales 1221

 

How can I get this done in Power BI?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
JoseHop
Helper I
Helper I

@amitchandak thank you! It works!

amitchandak
Super User
Super User

@JoseHop , Create a date table and follow the active employee code

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.