Forum Discussion

shep123's avatar
shep123
Helper I
9 years ago
Solved

Running 7 Day Total

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 t...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Use this MEASURE

     

    7 Day RT MEASURE =
    CALCULATE (
        SUM ( Table1[Value] ),
        DATESINPERIOD ( Table1[Date], LASTDATE ( Table1[Date] ), -7, DAY )
    )
Sean's avatar
Sean
Community Champion
9 years ago

Use this MEASURE

 

7 Day RT MEASURE =
    CALCULATE (
        SUM ( Table1[Value] ),
        DATESINPERIOD ( Table1[Date], LASTDATE ( Table1[Date] ), -7, DAY )
    )