PeriodRolling Function is not working

Nicki

Summary

PeriodRolling Function is not working

Content

There is another thread about this without an answer. Trying to use PERIODROLLING to calculate the total number of terminations over the past 12 months. The documentation does not make sense and is very limited. I noticed that whatever I do to the X and Y parameters, the same number comes up:

PERIODROLLING (measure, X,Y) where typically, X is negative and Y is positive.

My understanding is that X goes back a number of periods and Y is where it stops. Can X be Zero to represent current period? Very unclear unless someone has insight please?

Nicki

This displays the number correctly over the entire time period but changing the x and y does not change the result of the formula:

I could change the -7 and 7 to any number and there is no change.