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.
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!
Comments