Forum Discussion

coop2thehoop's avatar
coop2thehoop
New Member
1 year ago

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...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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