I have a dashboard that looks 3 weeks into the past at a weeks level. I have an indicator to look 3 weeks back in my measures etc. I have a text box and the top which i hard type the date range my dashboard is currently showing. Is there a formula to automatically bring the date range in?
I also have a previous month end section showing complance for last month and i need the title to change automaticall in there as well when we have a new month.