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!

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

AG_PBI 

New Measurs

Total Volume = SUM('YourTableName'[Volume])
Weekly Running Avg Vol = 
AVERAGEX(
DATESINPERIOD(
'YourTableName'[Submission Week],
MAX('YourTableName'[Submission Week]),
-3,
WEEK
),
[Total Volume]
)

This should help you get the desired results in your Power BI report.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn