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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Work experience by employees position

Hello,

 

I have problem finding average employees work experience by position. I have two tables: Employees and Contracts.

 

Employees table:
EmpID

Name

Surname

Date of employment

Date of dismissal

 

Contracts table:

EmpID

Position

Department

 

Dax measure for employees work experience:

Work experience = YEARFRAC(Employees[Date of employment],Employees[Date of dismissal])

 

Example:

Employee    Position                 Work experience

Emp1           CEO                       10,1

Emp2           Administrator        2

Emp3           Administrator        8

Emp4           Administrator        6

 

Desired DAX measure result (measure will be used in column diagram):

CEO average experience = 10

Administartor average experience = 5.3

Myk_0-1642969937791.png

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , is one of the two measures not working

 

Average(Employees[Work experience])

AverageX(Employees,YEARFRAC(Employees[Date of employment],Employees[Date of dismissal]))

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , is one of the two measures not working

 

Average(Employees[Work experience])

AverageX(Employees,YEARFRAC(Employees[Date of employment],Employees[Date of dismissal]))

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors