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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Help

@Anonymous  this was a great post put on by you which I have used. I rolling 13 months. I need the data to be a Rolling 12 months.

How can I do this please?

Can @Anonymous or anyone else help?

 

This is the link - https://community.powerbi.com/t5/Desktop/Rolling-13-months-DAX/td-p/663677

 

Thanks

 

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please update the measures like this.

2Sales Rolling 12 ACT = 
VAR Maximum_Date =
    MAX ( 'Rolling Calendar'[Date] )
VAR Minimum_Date =
    EDATE(Maximum_Date,-11)
VAR Selected_Date =
    MAX ( 'Calendar'[Date] )
RETURN
    IF (
        Selected_Date <= Maximum_Date
            && Selected_Date >= Minimum_Date,
        [Sales ACT],
        BLANK ()
    )
2Sales Rolling 12 Month ACT (Totals) = 
IF (
    HASONEFILTER ( 'Calendar'[Date] ),
    [2Sales Rolling 12 ACT],
    SUMX ( 'Calendar', [2Sales Rolling 12 ACT] )
)

Capture.PNG

 

Also please check the pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please update the measures like this.

2Sales Rolling 12 ACT = 
VAR Maximum_Date =
    MAX ( 'Rolling Calendar'[Date] )
VAR Minimum_Date =
    EDATE(Maximum_Date,-11)
VAR Selected_Date =
    MAX ( 'Calendar'[Date] )
RETURN
    IF (
        Selected_Date <= Maximum_Date
            && Selected_Date >= Minimum_Date,
        [Sales ACT],
        BLANK ()
    )
2Sales Rolling 12 Month ACT (Totals) = 
IF (
    HASONEFILTER ( 'Calendar'[Date] ),
    [2Sales Rolling 12 ACT],
    SUMX ( 'Calendar', [2Sales Rolling 12 ACT] )
)

Capture.PNG

 

Also please check the pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

@v-frfei-msft brilliant thanks

Anonymous
Not applicable

Hi @Anonymous 
Would it help to use 

 

Sales Rolling 12 ACT = 
VAR Maximum_Date =
    MAX ( 'Rolling Calendar'[Date] )
VAR Minimum_Date =
    DATE ( YEAR ( Maximum_Date ) - 1; MONTH ( Maximum_Date ); DAY( Maximum_Date ) )
VAR Selected_Date =
    MAX ( 'Calendar'[Date] )
RETURN
    IF (
        Selected_Date <= Maximum_Date
            && Selected_Date > Minimum_Date;
        [Sales ACT];
        BLANK ()
    )

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors