Attached is a workbook that allows a user to choose a Date and select a View (Seasonal or YTD). I've created the following 4 calculations (each evaluates to True or False) based on the date chosen (let's say the user selects Mar, 10, 2017):
Season Current (Jan 1, 2017 - Mar 10, 2017)
Season Prior (Jul 1, 2017 - Sep 10, 2017)
YTD Current (Jan 1, 2017 - Mar 10, 2017)
YTD Prior (Jan 1, 2016 - Mar 10, 2016)
I created another calculation called 'Filter':
If the user selects the 'Season' view then ([Season Current] or [Season Prior])
If the user selects the 'YTD' view then ([YTD Current] or [YTD Prior])
I also created a 'Color By' calculation to make 'current' and 'prior' easy to identify.
I hope this helps,
If this post helps to resolve the challenge please mark it 'This helped me' and/or 'Correct Answer'. This will help other users find the same answer/resolution. Happy dashboarding!
Season vs YTD.twbx 1.2 MB