Work experience by employees position

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , is one of the two measures not working

Average(Employees[Work experience])

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