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" (...
Need Help
  • 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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

HugoJesus , In your script of addcolumns .

"Open_Tickets",
CALCULATE
(
SUMX(Filter(TempTable,Date_Link[Calendar] <= earlier(Date_Link[Calendar])),[Daily_Open_Tickets])
)

 

new column =SUMX(Filter(Total_Open_Tickets ,[Calendar] <= earlier([Calendar])),[Daily_Open_Tickets])

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

Sorry, is not working. Give to me the follow error.

 

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    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.

     

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

      Hi v-easonf-msft , 

       

      That's a miracle, I searched in many sites, but no one have mentioned something like this.

      It works perfectly, this is why I love to share my doubts here in this forum.

      Thanks a lot. 

      Regard's

      Hugo Jesus

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

      Hi v-easonf-msft,

       

      It is possible to create a Variable, with this code and create x-axis visualizations by date?

      Regard's

      Hugo Jesus 

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

        Sorry the correct term is "Measure" instead of "Variable".