7 day rolling total using DATEADD help as to why it doesn't work on the formula

Hello,
I have a question as to how dateadd works, I've done 7 day rolling totals just using minus 7 and DATESINPERIOD

Please Login or Register  to view this content.

and the same result ;

Please Login or Register  to view this content.

But I've tried to use Dateadd , I've put it into dax studio and for each 'row' using addcolumns it returned a date seven day prior to the current row date, but if I try the following I just get a a running total , I've tried change the 'Calendare [date] for the variable mdate but it didn't seem to make a difference, I've attached the work book any help as to why it doesn't work would be helpful.

Please Login or Register  to view this content.

Yes, I can see that, but it does work in excel, and I know things work differently,

Please Login or Register  to view this content.

also the same could be said where I've used the MAXDATE() variable, mdate - 7, but that seems to work,

I did try using MAX , VALUES and a few others to try and use the var with dateadd ,but no good.

Richard.

First Sorry not getting back to you before now,

Re the excel formula I've always just use a single unlocked cell for the criteria

Please Login or Register  to view this content.

, seem to work.
As to DATEADD, i have been trying to use it , but just get a cumulative total,

Please Login or Register  to view this content.

, I have tried putting the variable last clause ;

Please Login or Register  to view this content.

But doesn't seem to make a difference?

I had tried this before, and Values, but have not got it accepted, when I close on MAX and add a comma to move to number of intervals,
the MAX ( ) part is underlined red. It's really annoying as I cant see why it doesn't work.

Richard

Thanks,
I'll mark this up, yes, I know a bit weird, but I just wanted to see if it could be done, I find with a lot of DAX functions, just when you think you know how they work they give an unexpected result.
My next question is probably going to be AVERAGEX.
Thanks for the help,

RD