Calculating a moving month within 3 months

I am trying to calculate a moving 90 day period based on month. For example what I would like to see now is the date rolled up into DEC,JAN,FEB and as we move to next month I would expect to see JAN,FEB,MAR.

I know the current month function to get only the current month moving but having trouble integrating the following two months as well with it.


Let me know your thoughts...


Thanks

Answers

  • The quickest way I would solve for this is by putting a date range into the analyzer like so

    Alternatively you could probably do something like this as a beastmode then filter if NOT 'not my date'