Cumulative total with specific date and value

[Anonymous]

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

[aj1973]

Hi @Anonymous 

Your request is not clear!

Can you share more details, functions, measures, pictures, screenshots, Pbix file...

[Anonymous]

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$

[Anonymous]

Hi @Anonymous,

It should help us clarify your scenario and test to coding formula if you please share some dummy data with a similar data structure and expected results. 

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[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.

[Anonymous]

Hi Amine, 

Sorry for the delay.

Sales : the values came from a table. 

Cash Bank : 

CashBank = CALCULATE([Net Cash Flow],

FILTER(ALL('Calendar'), 'Calendar'[TheDate] <= MAX('Calendar'[TheDate])

)

)

[Anonymous]

@aj1973 could you please check your Facebook message

Thanks

[Anonymous · Accepted solution]

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 😉