Month to Date (MTD) Vs Previous Month to Date (PMTD)

MTD – Month to date is the period starting from at the beginning of the current calendar month and ending at the current date.

While

PMTD – Previous month to date is the period starting from the beginning of last calendar month and ending at the current day of last month.

So, how do I compute MTD and PMTD in Tableau?

In this post, I will share several formulas you can use to compute MTD Sales and PMTD Sales.

Computing MTD Sales

Assuming data updates daily, these calculations can also be recalculated by simply replacing TODAY() with maximum order date which is calculated as follows;

Computing PMTD Sales

The same calculations for PMTD above, can also be achieved by replacing TODAY() with {MAX([order date])}

I know one of the above calculations will serve your purpose in computing MTD and PMTD respectively.

Useful: Computing week to date (WTD) vs previous week to date (PWTD)

Useful: Computing quarter to date (QTD) vs previous quarter to date (PQTD)

Useful: Computing year to date (YTD) vs previous year to date (PYTD)

If this post was helpful and you would like to receive more of these Tableau tips and tricks, kindly subscribe to our mailing list below.

If you like the work we do and would like to work with us, drop us an email on our Contacts page and we’ll reach out!

Thank you for reading!