Forum Discussion

HugoJesus's avatar
HugoJesus
Icon for Helper IV rankHelper IV
6 years ago
Solved

Cumulative Using Summarized Table

Hello everyone,  First of all, I'll explain what I'm trying to do.  1. Create a Summarized Table with the following columns "Calendar", "Created Tickets", "Closed Tickets", "Daily Open Tickets" (...
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi,  HugoJesus 

    Try to modify the formula as below:

    ...
    .....
    VAR LastDay =
        MAX ( Date_Link[Calendar] )
    VAR TempTable2 =
        ADDCOLUMNS (
            TempTable,
            "Open_Tickets",
            var _date = [Calendar]
            return
                SUMX(
                    FILTER(
                        TempTable,
                        [Calendar]<=_date
                    ),
                    [Daily_Open_Tickets]
                )
        )
    RETURN
        TempTable2

    The result will show as below:

     

    Please check the attached pbix file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.