Forum Discussion

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper IV
5 years ago

Rolling 3 month calculation

Hello,   i have the below measure that functions correctly for rolling 3 month turnover.  The issue I am having is that if an associate terms at the end of a month, they are counting in that months...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

LASTDATE('Date Table'[Full Date])-1

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper IV
5 years ago

I tried that but it excludes from all eom headcount, I want to include month end terms from my datesinperiod timefreame.  So, for rolling 3 month, I want to exclude those who termed 3/31/2021 but include 2/28 and 1/31.

DATESINPERIOD(
'Date Table'[Full Date],
LatestMonth,
-3,
MONTH
)
) *4
/