Calculating a Rolling 12-Month Value with DATEDIFF() in Tableau Desktop

Publish Date: Mar 26, 2026

Task

How to create a calculated field for a rolling 12-month period of a value using DATEDIFF.

Steps

The following example is based on the Superstore sample data source.

Go to Analysis > Create Calculated Field.
Enter the following calculation: IF (DATEDIFF('month',[Order Date],TODAY()))<=12 THEN [Sales] ELSE null END
Enter desired name for the field.
Click OK.

Knowledge Article Number

001458304

Did this article solve your issue?

Let us know so we can improve!