Sum of current period + previous periods

[charliee]

Hello,

I'm looking for DAX formula (measure) which gives me result of the following calculation.

For each period i want to calculate sum of hours of current period + all previous periods.

Period	Hours	Sum
1	10	100
1	15	100
1	25	100
1	50	100
2	60	300
2	40	300
2	30	300
2	70	300

Many thanks!

[FreemanZ · Accepted solution]

hi @charliee 

Try to plot a visual with Period column and a measure like:

HoursSum =

CALCULATE(

   SUM(TableName[Hours]),

   TableName[Period]<=MAX(TableName[Period])

)

[charliee]

@FreemanZ thank you! That works!