KNOWLEDGE BASE

Finding End of Month or End of Quarter Dates


Published: 14 Jun 2017
Last Modified Date: 20 Jun 2017

Question

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

Environment

Tableau Desktop

Answer

To find and use end of month date:

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

To find and use end of quarter date:

  1. Create calculated field with the following calculation:
    DAY([Date] + 1) = 1 AND (MONTH([Date] + 1) = 4 OR MONTH([Date] + 1) = 7 OR MONTH([Date] + 1) = 10 OR MONTH([Date] + 1) = 1)l
  2. Add calculated field to the filters shelf.
  3. Select True.

 

Did this article resolve the issue?