Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am trying to create a rolling 6 week view of a count.
It should be simple - an aggregate of weekly totals for the last 6 weeks of daily data. Put into a line graph.
I am following this guide:
http://www.powerpivotpro.com/2013/07/moving-averages-sums-etc/
But running into an error when I try select the number of intervals as below:
Any ideas as to why?
I realise it says day in my example. I was testing it on a day to day moving visual before creating the 6 week. I also see that PowerBI does not have a week option, any help in creating that would be appreciated too.
Solved! Go to Solution.
Hi @fyrworx,
Please modify your DAX formula as:
3 Month Moving Sum Units Sold = CALCULATE ( SUM ( 'Moving Average'[Compliant] ), ALL ( 'Moving Average' ), DATESINPERIOD ( Dates[Date], LASTDATE ( Dates[Date] ), -3, DAY ) )
Thanks,
Yuliana Gu
I seem to have figured out the error but can't get the visual to work the way I want it.
Apparently the syntax requires a space after the number of intervals, before the ",".
Which doesn't make sense. Anyone else have this issue?
Hi @fyrworx,
Please modify your DAX formula as:
3 Month Moving Sum Units Sold = CALCULATE ( SUM ( 'Moving Average'[Compliant] ), ALL ( 'Moving Average' ), DATESINPERIOD ( Dates[Date], LASTDATE ( Dates[Date] ), -3, DAY ) )
Thanks,
Yuliana Gu
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |