Forum Discussion

aabati68's avatar
aabati68
Frequent Visitor
2 years ago
Solved

Please help with CALCULATE and FILTER dax function

I know the way I am trying to solve this is not elegant at all, but I do have a simple table called "HR Data" and a measure define like this: Headcount Employees = CALCULATE(DISTINCTCOUNT('HR Data'...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Heacount Employees One Year Before = CALCULATE(sum('HR Data'[Headcount Employees]),OFFSET(-4,allselected('HR Data'),MATCHBY('HR Data'[Index])))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Headcount Employees one year before =
CALCULATE(DISTINCTCOUNT('HR Data'[Employee Id]), SAMEPERIODLASTYEAR(Calendar[Date]))

 

(if you don't have a Calendar table then you should add one).