KNOWLEDGE BASE

Calculate The Remaining Days This Year / Month


Published: 26 Jan 2023
Last Modified Date: 26 Jan 2023

Question

How to calculate the remaining days this year or this month.

Environment

Tableau Desktop

Answer

Remaining Days This Year

Create the following calculation: 
DATEADD('year',1, DATETRUNC('year',TODAY()) ) -TODAY()

Remaining Days This Month

Create following calculation: 
DATEADD('month',1, DATETRUNC('month',TODAY()) ) -TODAY()
Did this article resolve the issue?