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, ...
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!

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!

     

    • 12400727's avatar
      12400727
      Frequent Visitor
      5 years ago

      Hi 

      Thanks for your help, i applied already your solution, but i have a quiestion for you, how can i apply a sum by customer, for example like you see the table below

      The customer Carolina Marín Garcia has two records with value equal 2, but i want show the value 4, i want sum both records. 

      The measure called Recambio is the below

      I gratefull your help.

       

      Best regards

       

      Hernando.

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Community Support
        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!