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!
Tableau date period comparisons and calculations work great as long as you use a conventional calendar. If your organization uses a non-standard calendar (e.g. your fiscal year doesn’t start on January 1st or you have comparison periods like semesters which aren’t native to Tableau), you probably need to create and integrate your own calendar with your data source.
Check out this week’s video to learn how you can utilize functions in Excel to assist you in quickly and accurately creating a custom business date calendar in Excel.
Want to dive deeper? Join us for our upcoming webinar on Thursday, June 24th, Academic Years + Tableau: All You Need to Know.
You can check out our upcoming classes on office hours here!