Forum Discussion
Cumulative total with specific date and value
Hi there,
I’m trying since yesterday to find a solution for a specific issue concerning the cumulative total from a specific and forcing to add a specific value.
The specific date is 2021/03/01 and the value is 32000$
So, I need to see something like that:
Date Sales Cash Bank
2021/03/01 2356$ 32000$
2021/03/08 5688$ 37688$
If anyone has a solution or a way to resolve this report that can be very helpful.
Thank you all for your help
Hi family,
Sorry if I didn’t bring a lot of information
I find finally the solution with two measures as you can see here :
1- Cumulative Cash Balance = CALCULATE([Net Cash Flow],FILTER(ALL('Calendar'),'Calendar'[Week]<= MAX('Calendar'[Week]) && 'Calendar'[Week] > DATE(2021,03,01)))
2- Cash Balance = CALCULATE(3200000 + [Cumulative Cash Balance], FILTER('Calendar','Calendar'[TheWeek] <>DATE(2021, 03, 01)))
Thanks all for your help and hope this post can help others with the same issue 😉
7 Replies
- aj1973
Community Champion
Hi Anonymous
Your request is not clear!
Can you share more details, functions, measures, pictures, screenshots, Pbix file...
This what I have now :
I make a filter to see only data from 03/01/2021
What I need, is to change the first value of the Cash Balance from $210,310 to $320,000
So then, the cumulative of the Cash Bank will be $-169,675.4 and not $-279,365
Date Sales Cash Bank
2021/03/01 211,722.75$ 320,000$
2021/03/08 489,675.40$ -169,675.4$
- aj1973
But where these amounts are coming from? what are the measures behind the calculations? How do you get $320,000 instead of $210,310!
Are you able to share a Sample file? it would be faster for all the community to understand and help you.
