Cumulative total

[vjnvinod]

Hi Experts,

i am looking for a cumulative sum based on combination on Period and Week for example 

this is the output i am looking for

My Current DAX is 

YTD Charged Hours =

CALCULATE(

    SUM('YTD Timesheet'[Hours]),

    'YTD Timesheet'[H Category] = "Chargeable"

)

i want to modify this pls note that 

i am using a Calendar table  with one to many relationship with Charged Hours table using Week Coloumn

[ThxAlot · Accepted solution]

This is the scenario where WINDOW functions come into play. Tweak the measure accordingly.

[Sergii24]

Hello @vjnvinod, you might find useful this blog post to solve your problem - link.

Good luck!