Forum Discussion
Labour Turnover Rate
Hi I have month start snapshot data going back to 1st April 2021 for employees in post. Anonymised examples below...... ...
YukiK
Impactful Individual
Impactful IndividualIf you have an index column per month-year then you can probably do something like this:
CALCULATE(
SUM(yourMeasure),
FILTER(
ALLSELECTED(monthyear),
ISONORAFTER(monthyear, MAX(monthyear), DESC)
)
)
/
SELECTEDVALUE( yourIndex )
Hope this helps!