Forum Discussion

AG_PBI's avatar
AG_PBI
Frequent Visitor
1 year ago
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 ...
Need Help
  • AG_PBI's avatar
    AG_PBI
    1 year ago

    I figured it out. In the RunningSum calculation, it should be ALL('submit') instead of ALL('submit'[Submission Week]). Then it worked. Thanks!

AG_PBI's avatar
AG_PBI
Frequent Visitor
1 year ago

I figured it out. In the RunningSum calculation, it should be ALL('submit') instead of ALL('submit'[Submission Week]). Then it worked. Thanks!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AG_PBI ， hello ,rajendraongole1, thank you for your prompt reply!

Congratulations on solving this issue and thanks for sharing your solution.

 

Please remember to accept your solution as answer.

 

It will do great help to those who meet the similar question in this forum.

 

Thanks again for your contribution.