Dynamic filter to keep rolling N months

Hi,

I have a dataset with 18 months of data. Each month a new month is appended to the existing dataset. I'd like to create a filter that keeps only the most recent 14 months (rolling 14 months). I've attached a simple workflow.

The Date Filter tool would work if I could dynamically specify the "end date" as the most recent date in the Month column. Any suggestions would be much appreciated.

Thanks.

RollingNmonths.yxmd

Preparation

Accepted answers

jack_morgan

Hey jjc42,

I modified your workflow to account for a dynamic 14 months. Give it a shot!

Jack

RollingNmonths.yxmd

All comments

jack_morgan

Hey jjc42,

I modified your workflow to account for a dynamic 14 months. Give it a shot!

Jack

RollingNmonths.yxmd

jjc42

Thanks, Jack. That did it!

mhayashi

Thanks Jack! I found this usefull as wel.

MPCNA

Hi, Jack, I think your workflow will solve my exact problem as well. Only change would be in my case, I don't want a rolling 14 months. I want it to append every new month starting with 201803. Reason being, I began running this workflow back in March and want to make it more dynamic than adding on a new filter each month.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157