Forum Discussion

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
10 years ago
Solved

Rolling 6 week average

Hi I think I am missing super simple here but I cannot get this working. I want to show a rolling 6 week average which is working and I want to show a rolling 6 week same period last year. I have the...
Need Help
  • samdthompson's avatar
    samdthompson
    5 years ago
    CALCULATE([Op $/kg],DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-42,DAY))
samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
5 years ago
CALCULATE([Op $/kg],DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-42,DAY))