calculate Running sum over Date

[Anonymous]

Hi all,

I want to calculate running sum over date. In the data shown i want to calculate column c (which is cooming from column B)

Thanks

[Ashish_Mathur]

Hi,

Create a Calendar Table and build a relationship from the Date column of your Data Table to the Date column of the Calendar Table.  To your visual, drag Date from the Calendar Table.  Write these measures

GP Total = SUM(Data[GP])

Cumulative GP Total = CALCULATE([GP Total],DATESBETWEEN(Calendar[Date],MINX(ALL(Calendar),Calendar[Date]),MAX(Calendar[Date])))

Hope this helps.

[Anonymous · Accepted solution]

Try this formula: 

Running Total = 
CALCULATE (
    SUM ( TableName[gp] ),
    FILTER (
        ALL ( TableName[date] ),
       TableName[date] <= MAX ( TableName[date] )
    )
)