Forum Discussion
Rolling 52 week average help
Hi,
I am trying to set a rolling 52 week view in power BI and was trying to figure out the the best way to do this? We have a week column in a calendar and bascially want it to show sales by week back 52 weeks and then roll forward each week. Think there will need to be some sort to min max date filter on the page like Min date = today() -365? Any help would be greatly appreciated!
5 Replies
- lbendlin
Super User
it is 363, not 365 (assuming you include today)
You can use the WINDOW function for this, it is the most flexible option.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 Hi coop2thehoop,
Thanks lbendlin for Addressing the issue.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay Pabbu
v-kathullacCommunity Support
Hi @coop2thehoop,
Thanks @lbendlin for Addressing the issue.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Chaithanya.- v-kathullac
Hi @coop2thehoop,
Thanks @lbendlin for Addressing the issue.
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Chaithanya. - v-kathullac
Hi coop2thehoop ,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,Chaithanya.
