Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 😉

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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