KNOWLEDGE BASE

Finding End of Month or End of Quarter Dates


Published: 14 Jun 2017
Last Modified Date: 23 Aug 2019

Question

How to find end of month date or end of quarter date.

Environment

Tableau Desktop

Answer

See the attached workbook. To find and use end of month dates:

  1. Create a calculated field with the following calculation: 
    DAY(DATEADD('day', 1, [Order Date])) = 1
  2. Add calculated field to the filters shelf.
  3. Select True.

To find and use end of quarter dates:

  1. Create calculated field with the following calculation: DATEADD('day',-1,DATEADD('quarter',1,DATETRUNC('quarter',[Order Date]))) = [Order Date]
  2. Add calculated field to the filters shelf.
  3. Select True.

 

Did this article resolve the issue?