Tableau Desktop snippets

How to calculate last day of Month

Suppose to start from a Tableau Desktop workbook with the data of Star Wars saga movies release date.

// Last day of Month
DATE(
    DATEADD('day', -1,
        DATEADD('month', 1,
            DATETRUNC('month', [US Release Date])
        )
    )
)
Tableau desktop

You can download a working example of this Tableau Desktop workbook in the Resources area.

Back to Tableau Desktop cookbook page