Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Labour Turnover Rate

Hi   I have month start snapshot data going back to 1st April 2021 for employees in post.  Anonymised examples below......                                              ...
Need Help
YukiK's avatar
YukiK
Impactful Individual
4 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    YukiK 

     

    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.