Forum Discussion

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
9 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))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi samdthompson

 

  Can you please provide some sample data like table names,column names with data.

 

Regards,

Hemant