Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
fyrworx
Frequent Visitor

DATEINPERIOD issues

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:

Capture.PNG

 

 

 

 

 

 

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.

 

1 ACCEPTED 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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
fyrworx
Frequent Visitor

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.