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
liboyjoseph
Frequent Visitor

Same period compare to a specific year

Hi team

Need your help on this please.

 

I want to create a mesure to compare same period to 2019. instead of same period last year, I need same period 2019. 

I've below measure and it works fine when my current date selection is on 2022, I want to compare all my dates to 2019.
 
Y3 = CALCULATE([Total Sales TY],DATEADD('Date'[Date], -3, YEAR)) 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@liboyjoseph , if you always was 2019

 

Y3 =

var _diff = 2019 - maxx(allselected('Date'), 'Date'[Year]) )

//or var _diff = 2019 - year(maxx(allselected('Date'), 'Date'[date]) ))

return

CALCULATE([Total Sales TY],DATEADD('Date'[Date], _diff , YEAR))

View solution in original post

3 REPLIES 3
liboyjoseph
Frequent Visitor

Thank you @amitchandak Your solution work perfectly

amitchandak
Super User
Super User

@liboyjoseph , if you always was 2019

 

Y3 =

var _diff = 2019 - maxx(allselected('Date'), 'Date'[Year]) )

//or var _diff = 2019 - year(maxx(allselected('Date'), 'Date'[date]) ))

return

CALCULATE([Total Sales TY],DATEADD('Date'[Date], _diff , YEAR))

Hi, I want to make a measure to compare every last 4 year to 2017, same period. 2017 is my reference year to calculate an evolution for 2018, 2019, 2020 ...   

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.

Top Solution Authors