Forum Discussion
Prev Year FTE Number - Issue with DateAdd
Hi - I would like to calculate the headcount number for the latest actual month and compare it with the same period last year. I already calculated the latest actual month headcount and it is worki...
FreemanZ
Super User
Super Userhi dkotiloglu
In DATEADD function, try to use the date column from the calendar table.
Thanks, tried however same, unfortunately.
- FreemanZ
hi dkotiloglu
in your screenshot, it shows the calendar table definition. I meant to change in your PY FTE definition to
PY FTE=CALCULATE([Latest FTE], DATEADD('Calendar'[Date], -1, YEAR))