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
    /