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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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