Forum Discussion
Solved
Weekly running average
Hi, I am new to Power BI and this is my first report. I have a dataset as follows: Loan Number Submission Week Volume Loan1 1 1000 Loan2 1 2000 Loan3 1 2000 Loan4 2 3000 ...
I figured it out. In the RunningSum calculation, it should be ALL('submit') instead of ALL('submit'[Submission Week]). Then it worked. Thanks!
Thanks for your swift feedback. But it is not working as expected. I split the code and found that 'RunningSum' is exactly same as 'Total Volume'. It is just giving the sum of that week itself instead of doing the total with previous week(s).