Hi, I'm trying to do a 7 day rolling total in DAX, I've followed a similar structure to what I'd do in excel, in excel I wouldn't have the first condition, just greater than; DATEADD(Table1[Date],-7,DAY)) > I know there is 'dates in period' but i don't have a calendar table in this instance. I'm sure i've managed this in the past but don't seem to have saved a copy. Help, Richard.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

DAX Rolling 7 day total

Thread starter dicken
Start date May 3, 2022
Tags

dax running total total amount

dicken

Active Member

May 3, 2022

Hi,
I'm trying to do a 7 day rolling total in DAX, I've followed a similar structure to what I'd do in excel, in excel I wouldn't have the first condition, just greater than;

< moving := VAR abc = MAX(Table1[Date]),
RETURN
CALCULATE([sumofunitsl],
FILTER(ALL(Table1[Date]),Table1[Date]<=abc && Table1[Date] > DATEADD(Table1[Date],-7,DAY)) >

I know there is 'dates in period' but i don't have a calendar table in this instance. I'm sure i've managed this in the past but don't seem to have saved a
copy.

Help,
Richard.