Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a Data file that goes like this..
Year.Week Bookings.Value
201850 5
201850 3
201850 3
201850 2
201850 0
201851 . . .
. . .
201852
. . .
201901
. . .
201902
. . .
How can I make a column that gives me a running total?
So something like:
Cummulative.Week Cummulative.Value
201850 13
201851 = 13 + (201851)
. . . . . .
Solved! Go to Solution.
Hi @Anonymous ,
In your scenario, you can create a measure:
Cummulative.Value = CALCULATE ( SUM ( Table1[Bookings.Value] ), FILTER ( ALL ( Table1 ), Table1[Year.Week] <= MIN ( Table1[Year.Week] ) ) )
The result will like below:
Best Regards,
Teige
Hi @Anonymous ,
In your scenario, you can create a measure:
Cummulative.Value = CALCULATE ( SUM ( Table1[Bookings.Value] ), FILTER ( ALL ( Table1 ), Table1[Year.Week] <= MIN ( Table1[Year.Week] ) ) )
The result will like below:
Best Regards,
Teige
@Anonymous,
There you go:
Cumulative Bookings Value := CALCULATE ( SUM ( 'TableName'[Bookings.Value] ), FILTER ( ALL ( 'TableName'[Year.Week] ), 'TableName'[Year.Week] <= MAX ( 'TableName'[Year.Week] ) ) )
All that is doing is returning the original Bookings.Value numbers... Which makes no sense based on the formula but that is what I'm getting
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |