Sum Cumulative by Date

[12400727]

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

[v-xulin-mstf]

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!

[v-xulin-mstf]

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]

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]

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]

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 · Accepted solution]

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!

[12400727]

Hi

i got an error, but i don't know what is the error. please help

Best regards.

[v-xulin-mstf]

Hi @12400727,

Your code has a formatting error.

Please refer: https://docs.microsoft.com/en-us/dax/sumx-function-dax

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!

[negi007]

@12400727  Below article can help you in creating a mesure to calculate running total

for future months

https://community.powerbi.com/t5/Desktop/running-sum-of-future-3-month-data/m-p/663335

for past months, much more detailed here

https://www.goodly.co.in/running-total-power-bi/

[12400727]

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.

[12400727]

Hi neggi007

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