How to calculate weekly running total

[slav84]

Hi, 
I have table called WeeklyData with columns FiscalWeek and Count. 
I need to add another column (Not Measure)  that will have running totals. So for example in row of RunningTotal we would have 132, row two would be 132+654 and so on.
How would i do that ?

FiscalWeek	Count
1	132
2	654
3	987
4	498
5	658
6	738
7	918
8	658
9	468
10	681
11	95
12	128
13	642
14	379
15	728
16	291
17	675

[mahoneypat · Accepted solution]

Here is a column expression that works.  Replace T1 with your actual table name.

RT =
VAR thisFW = T1[FiscalWeek]
RETURN
    SUMX ( FILTER ( T1, T1[FiscalWeek] <= thisFW ), T1[Count] )

Pat

[slav84]

Thank you. This worked like charm 😉