Example: Last 7 Days of the same period last year.
We have the data for this but need help regarding my dimension/measures etc. as my brain has gone a little dry.
My current expression:
Sum({<YearMonth={'$(v0MonthsYearAgo)'},$(vOmitSelection_YearMonth)>}$(vSelected_Portal_Measure))
So to clarify I am looking to see the last 7 days of this particular period and will want the same for YTD values. So YTD but the last 7 days of the YTD and so forth.
My brain is totally frazzled trying to figure this out so any help is greatly appreciated amongst you gurus.
Thanks and happy weekend 🙂