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!

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.