I need to get report like this: current day, same day last week, current month, last month this column will represent average value for some measure.
Another request is: if current day is eg. Monday in columns current month I have to present average values just for Mondays in current mont, same for previous month it should show average value for all Mondays in previous month.
I have produced this report putting Monday in context/slicer, and it is OK.
Question: how to prepare this report in daily changing manner? Idea is to check current day and change context, but how to automate this procedure without any prompts? Any ideas?