Work experience by employees position

Anonymous — Sun, 23 Jan 2022 20:33:59 GMT

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

Re: Work experience by employees position

amitchandak — Mon, 24 Jan 2022 03:47:31 GMT

Anonymous , is one of the two measures not working

Average(Employees[Work experience])

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