Simplify Cumulative Formula

Anonymous — Fri, 15 Jan 2021 03:50:51 GMT

https://drive.google.com/file/d/1K08wErvFMTg_SoqWxZWO4x0WECyD99Q8/view?usp=sharing

In the attached file, Final to Collect (4) is arrived after calculating 1,2,3 steps.
Is there anyway to simplify this calculation,
The basic logic is as below:

From the To Collect need to subtract Unapplied Receipts

Eg A :
In this case Unapplied Receipts < 2021 January To Collect (15 < 25 )
For 2021 January , Final To Collect =To Collect -Unapplied Receipts = 25-15 = 10
For 2021 February, Final To Collect= To Collect=3
For 2021 March, Final To Collect= To Collect=40

Eg B :
Suppose Unapplied Receipts was 30
In this case Unapplied Receipts > 2021 January To Collect (30 > 25 )
For 2021 January , Final To Collect =To Collect -Unapplied Receipts = 25-30= Since 30 is not fully subtractable from 25, 5 will be subtracted from 2021 February
therefore, for 2021 January ,Final To Collect = 0

For 2021 February, Final To Collect= To Collect -Unapplied Receipts=3 -5=
But since 5 is not fully subtractable from 3, 2 will be subtracted in March
therefore, for 2021 February, Final To Collect = 0

For 2021 March, Final To Collect= To Collect -Unapplied Receipts=40-2
Final To Collect = 40-2 = 38

For 2021 April, Final To Collect = To Collect …and so on…

My question is, to perform this logic, current I am performing steps 1,2, 3,4 as shown in the picture.
Is there any easier way of doing this?

Re: Simplify Cumulative Formula

wdx223_Daniel — Tue, 19 Jan 2021 00:56:43 GMT

Anonymous

Re: Simplify Cumulative Formula

Anonymous — Wed, 20 Jan 2021 11:28:54 GMT

Can you attach pbix

Re: Simplify Cumulative Formula

wdx223_Daniel — Thu, 21 Jan 2021 00:41:22 GMT

Anonymous FYI

topic Re: Simplify Cumulative Formula in DAX Commands and Tips

Simplify Cumulative Formula

Re: Simplify Cumulative Formula

Re: Simplify Cumulative Formula

Re: Simplify Cumulative Formula