Running Total Help

Thanks for the reply from foodd andrajendraongole1，please allow me to provide another insight:
Hi,PIYUSHPRAJAPATI 
Regarding the issue you raised, my solution is as follows:

1.As for your question, our answer is that your answer is correct, in powerbi if you want to use dax to implement the first three data accumulation and so repeated, is a typical recursive problem, which is difficult to achieve in powerbi using dax.

Solved: Recursion in DAX - Microsoft Fabric Community

2.You can try doing the calculation in excel first and then importing it into power bi. This is by far the easiest way. Here is a link to the relevant documentation:
How to create recursive functions in Excel with LAMBDA (spreadsheetweb.com)

3.You can also implement this function in PowerQurey, but you need to invest more effort:

Here is a link to the relevant documentation:

Recursive Functions in Power Query | Power BI Data (enterprisedna.co)

Of course, you are welcome to share your new findings with us.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.