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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nmck86
Post Patron
Post Patron

3 mos avg vs previous 3 months avg

I am able to calculate my rolling 3 months

 

Rolling 3 Mo =
CALCULATE (
    TBL[VALUE],
   DATESINPERIOD (
        'Calendar'[Date],
        LASTDATE( PREVIOUSMONTH( 'Calendar'[Date]) ),
        -3,
        MONTH))

 

However, now I want to be able to look at the previous 3 months less current month... so my current calculation is looking at august, july, and june... now I want a calculation that will look at july, june, and may... any help on this you guys can provide?

1 ACCEPTED SOLUTION

Hi,

 

to get July to August, replace the DATESBETWEEN() function with this

 

DATESBETWEEN(Calendar[Date],EDATE(MIN(Calendar[Date]),-2),MAX(Calendar[Date])))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

23 REPLIES 23

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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