Forum Discussion
How to get 4 weeks rolling average?
Hello there,
I am trying to get the 4 week rolling average for revenue in 2022.
I have dataset that looks like this:
Notice that i have two different channels from which my revenue is generated.
So what i need to produce is a table that will look like this:
Basically i have to calculate rolling avergate for each channel and store it for each of my fiscal weeks.
I know how to do this in python but i need to get this to work in Power Bi.
Here is the link to my pbix and excel files:
https://1drv.ms/u/s!AhhZq1add5YwjoV7tAhrdGuZOAyN3A?e=ds4QiZ
Thank you so much.
6 Replies
- Ashish_MathurSuper User
You have not shared the download link of your files.
- AnonymousNot applicable
I am sorry my bad. The link is there now. 🙂
- Ashish_MathurSuper User
Hi,
Please also prepare a Calendar Table in the PBI with columns for Fiscal year, week numbers, month name and month number. Share the link of the revised PBI file.
- AnonymousNot applicable
I have now included that as well. Thank you for helping with this. The link to the PBI file shold be the same.
- Ashish_MathurSuper User