Forum Discussion

12400727's avatar
12400727
Frequent Visitor
5 years ago
Solved

Sum Cumulative by Date

 

Hello

How can i achive that if I filter a date, it makes me the sum the amounts of the three months forward, and in a table it shows me the year, the months and the sum of the amounts by months, for example, if I filter 01/01/2021, show me the sums of the quantities in the months, January, February and March 2021, i did measurement, which does this to me, but the table does not show me the months these sums of quantities correspond.

 

Measure

Table

Date Filter

 

 Pleas your help

 

Best Regard

 

Hernando

Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi 12400727

     

    Try measure as:

    SUMX(
    FILTER(
        ALL(Table1),
        Table1[Customer])=MAX(Table1[Customer])
    ),
    [3 Meses]
)

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

11 Replies

    • 12400727's avatar
      12400727
      Frequent Visitor
      5 years ago

      Hi neggi007

       

      I have a question for you, what i should put om what is highlighted in yellow?

       

       

    • 12400727's avatar
      12400727
      Frequent Visitor
      5 years ago

      Hi 

      i already made the two measurements, and pleaced them in a table, however i do not see the expected result, it is not adding the next three months when i filter the date in the slicer.

      For example i select the date 

       

      And the table shows the next

      It is showing the quantity of the day selected (3), and the quantities of the month of the selected day (166).

      i should see the sum of the three months following the selected day, only is showing the month of january.

       

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi 12400727,

     

    You can create a calculated table as:

    Table2 = 
VALUES('Table1'[Date])

    Create measure as:

    Measure = 
CALCULATE( 
    SUM('Table1'[Value]),
    DATESBETWEEN(
         'Table1'[Date], 
          ALLSELECTED('Table2'[Date]), 
          DATEADD(ALLSELECTED('Table2'[Date]),2,MONTH)
        )
)

    Here is the output:

    The pbix is attached, please try it.

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

     

    • 12400727's avatar
      12400727
      Frequent Visitor
      5 years ago

      Hi

      i craeted two measurement:

      1.

      2.

      Table Result:

      Selected Date

      i see the value 409 that corresponds to three months forward to the selected date, but my request is in order see in the table the years and the months that corresponds to the Three months forward, for example, if i select 03/07/2020, shows me the below image.

      What can i do?

       

      Thanks

       

       

       

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Community Support
        5 years ago

        Hi 12400727

         

        Is this what you want?

        The demo is attached, please try it.

        If you still have some question, please don't hesitate to let me known.‌‌

         

        Best Regards,

        Link

         

        Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

         

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi 12400727,

     

    Is your issue solved? If the issue has been solved, please adopt the solution to help others.

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!