Last Modified Date: 20 Dec 2019
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.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials