1 Reply Latest reply on Oct 31, 2016 3:28 AM by Norbert Maijoor

18 Month rolling Calendar Period

Divya Reddy Oct 30, 2016 10:15 AM

Would need to create a 18 month look ahead calendar period. if the report is run in October 2016 it should have 18 months from oct and if it is run in nov it should be 18 months ahead from November. Please help . Thank you

X -axis has Start dates. The filter to roll 18 months should be on this date.

1. Re: 18 Month rolling Calendar Period

Norbert Maijoor Oct 31, 2016 3:28 AM (in response to Divya Reddy)
Hi Divya,

Find my approach as reference below and stored in attached workbook version 9.3

1. Rolling 18 month ahead:

IF datediff('month',[Order Date],[Current date])<= 0 and datediff('month',[Order Date],[Current date])>=-18
then [Order Date] END

Rolling 18 month ahead.twbx 1.2 MB
Like Show 0 Likes(0)

Actions

Tableau Community Forums

18 Month rolling Calendar Period

1. Re: 18 Month rolling Calendar Period

Actions

More Like This