This video covers how you can create a parameter which is used in a Tableau dashboard to control two date ranges at once, a “selected period” (e.g. month to date) and a “comparison period” (e.g. previous month to date). This approach is extremely useful when your user has several time periods they want to cycle through, and they want period over period comparisons for each of the possible time periods. Summary tiles, bar charts, trending lines used for comparison are great landing spots for this method. This video provides an overview of how to use this approach, but it doesn’t cover every possible scenario. If you have questions about how to apply this or how to write a formula for a specific date period, feel free to drop a comment below and we’ll help you out! Resources: •Link to prequel video "How to Tableau: Custom Date Filter for Dashboard": •Link to Download Tableau Workbook: Connect with Us: •Book an Office Hour with Eric: •Upcoming Tableau Classes: •Follow Eric on LinkedIn: •Subscribe to the OneNumber Newsletter: Chapters: 0:00 Intro & Calculation Review 2:12 Parameter Creation 3:30 Selected Period Calculations 7:45 Comparison Period Calculations 11:29 Difference / Change Calculations 12:00 Period Label/Text Calculations 16: Outro