Running 7 Day Total

Question

I am trying to have a running total for the last 7 days. My table currently have Date and Value. I inserted a calculate column that I want to calculate the results for the previous 7 days. Since my table starts at 1/1 there will naturally be less than 7 days for the first 6 days of the year. However, beyond that I want to calculate the previous 7 day total based on only dates that fall in that range. So 1/7 would be all the values for 1/1 through 1/7 and 1/8 would be all the values for 1/2 through 1/8 and continuing on for the entire year. How can I accomplish this in DAX?&nbsp;Date &nbsp; Value &nbsp; Running 7 Day1/1 &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21/2&nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;51/3&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;61/4&nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101/5&nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;121/6&nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;151/7&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;161/8&nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;181/9&nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18&nbsp;&nbsp;

sean · Accepted Answer

Use this MEASURE&nbsp;7 Day RT MEASURE =
    CALCULATE (
        SUM ( Table1[Value] ),
        DATESINPERIOD ( Table1[Date], LASTDATE ( Table1[Date] ), -7, DAY )
    )

Forum Discussion

Running 7 Day Total

1 Reply

Related content

Running Totals

Running total

Waterfall Charts with running totals

SumX? - cumulative running total

Tableau to PowerBI Running Totals Issue