Last Modified Date: 20 Jul 2023
Environment
Tableau DesktopAnswer
Create a calculated field.For example, the attached workbook contains the calculated field [Last Day of Month], created with the formula below:
DATEADD('day',-1,DATEADD('month',1,DATETRUNC('month',[Order Date])))
This calculated field was placed on the Columns shelf and Exact Date was selected to achieve a view where the header displays the last day of the month.
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