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...



  • G_Grey
    G_Grey Contributor

    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'