By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can also sign up for a Tableau Office Hour to work with him directly!
The superstore data that Tableau provides is a helpful tool for practice, mockups and trying out concepts. However, one of the frustrations is that it can get “out of date” so to speak so the latest date in the data set might be December 31, 2021 even though today’s date is month’s later.
That’s particularly annoying when you are trying to test “To Date” calculations like Year to Date versus Previous Year to Date.
My colleague had a great idea and used the DATEADD function to make the last date in his superstore Order Date field today’s date.
Check out the video below to learn how you can apply this trick!
Here is the code for the calculated field:
DATEADD('day',
DATEDIFF('day',{MAX([Order Date])},TODAY())
,[Order Date])