Last 12 Months calculation in a Measure in Tableau March 18, 2020 Last 12 Months calculation in a Measure in Tableau Create a measure using the calculation below: IF ( [Report Date ] >=DATE(DATEADD('month',-11,Today() )) AND [Report Date] <=DATE(Today() )) THEN [ Total Sales ] END Read more