Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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]))
@Anonymous , is one of the two measures not working
Average(Employees[Work experience])
AverageX(Employees,YEARFRAC(Employees[Date of employment],Employees[Date of dismissal]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |