Forum Discussion
12400727
5 years agoFrequent Visitor
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, ...
- 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!
negi007
5 years agoCommunity Champion
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
5 years agoFrequent Visitor
Hi neggi007
I have a question for you, what i should put om what is highlighted in yellow?