Create a cumulative column from event based table

Hello, I have an event-based table, Accidents, with the following columns: - Date - User - Accident Type - Comment I would like to create a cumulative line chart from the data above, and...

NickolajJessen

4 years ago

Cumulative = 
Var _res =CALCULATE(
    COUNTROWS(Accidents)
    ,FILTER(ALL('Calendar'), 
        'Calendar'[Date] <= MAX('Calendar'[Date])
        && 'Calendar'[Date] >= (EOMONTH(MIN('Calendar'[Date]), -13)+1)
    )
)

Var _End =
    CALCULATE(
    COUNTROWS(Accidents)
    ,FILTER(ALL('Calendar'), 'Calendar'[Date] >= MIN('Calendar'[Date]))
)
Return
IF(_End>0,_res)

Forum Discussion

Create a cumulative column from event based table

Related content

Creating Cumulative Graphs

Cumulative Total

Create columns group

Creating cumulative percentage

Creating Cumulative Line Chart