Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Hiring Rate Dynamic Calculation

I want to calculate the hiring rate as a dynamic measure.   Ex: Hiring rate in 2018 = # of hires in 2018/ [(total hires on 12/31/2017 + Total Hires on 7/31/2018)/2] Similarly on Sept 1, 2018, the ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous create a measure something like this

     

    HiringRate = 

    VAR EmpCY = Calculate(Count of employees, filter(where date is max date in dataset & year = year(date field))

    VAR EmpPY = Calculate(Count of employees, filter(where date is max date in dataset in previous year & year = year(date field)-1)

    RETURN EmpCY/((EmpPY+EmpCY)/2)

     

    If you need more clarifications/exact formula, please post same dataset and power bi file.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous create a measure something like this

 

HiringRate = 

VAR EmpCY = Calculate(Count of employees, filter(where date is max date in dataset & year = year(date field))

VAR EmpPY = Calculate(Count of employees, filter(where date is max date in dataset in previous year & year = year(date field)-1)

RETURN EmpCY/((EmpPY+EmpCY)/2)

 

If you need more clarifications/exact formula, please post same dataset and power bi file.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you! I also tried creating a date table and linking all my dates there. That also worked.