Question
How to calculate number of days in each month?
Last Modified Date: 09 Dec 2022
Environment
- Tableau Desktop
Answer
Create a calculated field including the following formula. In this formula, the DATETRUNC function returns the first date of the current month and the DATEADD function adds 1 month to the first date of current month. Then, minus 1 day from the date to get the last date of the current month and the number of days is available by the DATE function.DAY(DATEADD('day',-1,DATEADD('month',1,DATETRUNC('month',[<Date Field>]))))
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials
Trending Articles
Results 1-3 of 49