HR Dashboard | Power Pivot | Excel Forum • My Online Training Hub

Trang chủ » Hr Dashboard Power Pivot » HR Dashboard | Power Pivot | Excel Forum • My Online Training Hub

Có thể bạn quan tâm

Mynda, you are AMAZING!!! I have gone through the HR Dashboard webinar several times and I am trying to replicate what you have done with our company data. The data goes back to 1968. We have 473 active employees. I created the Measurements and the PivotChart. I only want to view the past 4 years with the total headcount. When I select the past 4 years, the numbers only show for those years. What formula would I need to show the active employees with the new hires?

1st - Employee Count GOOD =CALCULATE(COUNT([EmpID]),FILTER(ALL('HRDashboard'[Date]),[Date]=MAX([Date])))

2nd - Active Employees - GOOD =CALCULATE([EmpCount],FILTER('HRDashboard',ISBLANK('HRDashboard'[TermDate])))

3rd - New Hires - GOOD =CALCULATE(COUNT([EmpID]),FILTER('HRDashboard','HRDashboard'[isNewHire]="Yes"))

ACTIVE EMPLOYEES Tenure Days = =DAYS(TODAY(),F10) OR =DATEDIF(F4,TODAY(),"d") Tenure Months = =DATEDIF(F3,I3,"M") OR =DATEDIF(F4,TODAY(),"m") Tenure Years = =DAYS(TODAY(),F10)/365.25 OR =DATEDIF(F4,TODAY(),"y")

TERMED EMPLOYEES Tenure Days = =DATEDIF(F2,I2,"D") Tenure Months = =DATEDIF(F2,I2,"M") Tenure Years = =DATEDIF(F2,I2,"Y")

 

Regards,

Mike

Từ khóa » Hr Dashboard Power Pivot