I just saw that your post went unanswered, I am surprised why it did because it is a well explained problem. Do you still need help with this? I just created something basic to give you an idea, you can of course modify it based on your needs or let me know if I was completely off the hook in interpreting this correctly. If you are looking for a date level summary, you are just one step away literally.
You can create and additional string parameter that lists day, week, month, quarter and year. Create custom dates from the order date dimension by right clicking the order date > transform > create custom date. Do that for all date levels you need. Create a calculated field over this parameter such as:
CASE [Date Part Selection]
WHEN 'Quarter' THEN [Order Date (Quarters)]
WHEN 'Month' THEN [Order Date (Month / Year)]
WHEN 'Year' THEN [Order Date (Years)]
WHEN 'Day' THEN [Order Date (Days)]
Instead of having the actual order date on columns, place this calculated field on columns as exact date and discrete.
You can now choose the date level at which you need your data to be displayed. Hope this helps.
The numbers are still off though.
If you look at the calculation results when switching between daily, monthly etc, they differ greatly.
This is because the targets set are at a daily level. Im looking for a way to continue to apply the figures to daily figures but view from a monthly or quarterly level.
My work around for now is to use the trend average lines.