One relatively simple adjustment would be to change the Day Pill to discrete.
But that will just give you day numbers instead of actual dates.
You could also create an adjusted Date:
Bus Dat New
// Adjust the date for the prior period. IF [Dates to Include]="Previous" THEN // push the dates forward a month. DATEADD('month', 1, [Bus Dat]) ELSE [Bus Dat] END
Average Daily Sales (1).twbx 59.0 MB
Along the lines of what Ken said, you can shift your previous period by the corresponding value depending on your parameter and then make a few adjustments for the tooltip. I've attached a workbook which takes care of all your cases.
Let me know if this helps!
Average Daily Sales.twbx 59.0 MB
Wow! Thanks so much Ken and Rohit. Both solutions worked perfectly. For some reason I really struggled with this yesterday. I knew the solution was probably not that difficult, but I just wasn't seeing it. I don't know what I would do sometimes without the Forums.
A great day to you both!
Always happy to help! Thank you and have a great weekend!
No problem. Any time!!