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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pnem
Frequent Visitor

SAMEPERIODLASTYEAR over multiple year

Hello
I would like to know if is there a function that resembles SAMEPERIODLASTYEAR but that can be expanded to more than one year back? Like the average of a monthly value for the same month the last five years?
Thanks!

1 ACCEPTED SOLUTION
Uspace87
Resolver III
Resolver III

@pnem 

 

you can use DATEADD, just change the number of intervals you want to go back

 

Measure = CALCULATE(
    [Sales amt],
   DATEADD(Date_Table[Date],-2,YEAR
))

View solution in original post

2 REPLIES 2
Uspace87
Resolver III
Resolver III

@pnem 

 

you can use DATEADD, just change the number of intervals you want to go back

 

Measure = CALCULATE(
    [Sales amt],
   DATEADD(Date_Table[Date],-2,YEAR
))
pnem
Frequent Visitor

Thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors