Tableau Tableau / Date calculations

How to calculate first Monday of a given Month

Nicola Simboli 13 July 2021 1 min read

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

// First Monday of Month
DATE(
    DATETRUNC('week',
        DATETRUNC('month',[US Release Date])+6,
        'Monday'
    )
)

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

Tableau Cloud Audit / Alpha

Using Tableau Cloud?

Try the free collector. Bring site metadata and activity into a local DuckDB file and help test it against real environments.

Try the free collector

Nicola Simboli

Senior Analytics Engineer at Docebo. 15+ years across SaaS, consulting, energy and logistics; I own a visualisation platform serving 1,000+ internal users.

See my work & outcomes