I need help with a simple format. Below you can see that my PY and CY dates start on the same row, but last year is WED and this year is THU. Is there a way to offset this year from last year so the Thursday's line up. Another words..6/1/2016 Wed will show data for PY..but CY will be blank....then row for 6/2/2016 will show PY for Thu...but CY will show 6/1 data for Thu. The dates are coming from a calendar.
K...Now I'm running into another issue. When I place my PY counts in then they do not line up with the New PY dates. The counts are still reflecting a year ago based on the chosen date. I've tried filtering a measure by New PY date, but I'm not able to get it to work. Thoughts?