• Bernard

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

Updated: May 25


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 achiev by replacing TODAY() with {MAX([order date])}

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

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.

Thank you for reading.