cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to calculate measure for same period 2 years ago

Hi there,

 

I use SAMEPERIODLASTYEAR() to calculate measure for same period 1 year ago.

 

How do I do it for same period 2 years ago?


Thanks,

Wes

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to calculate measure for same period 2 years ago

@wes-shen-poal measurename = calculate(measure, parallelperiod(datetable[date], -2, year))

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
2 REPLIES 2
Super User
Super User

Re: How to calculate measure for same period 2 years ago

@wes-shen-poal measurename = calculate(measure, parallelperiod(datetable[date], -2, year))

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted

Re: How to calculate measure for same period 2 years ago

Thank you @vanessafvg