Last Modified Date: 24 Feb 2017
ResolutionUse calculated fields to define a fiscal month for the desired measure.
For example, Fiscal September Sales:
IF (DATEPART('month',[Order Date])=9 AND DATEPART('day',[Order Date])>5) OR (DATEPART('month',[Order Date])=10 AND DATEPART('day',[Order Date])<6) THEN [Sales] END
CauseThe ability to define custom start and stop days for fiscal months is functionality that is not currently available in Tableau Desktop.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials