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...... ...
If 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!
Hi, apologies if I am being a bit thick (!) but the sum function requires a column rather than a measure. What am I doing wrong? I get where you are coming from re an Index and was planning to use financial month number in my date table as the denominator in the calculation. Thanks.