cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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
Highlighted
Super User II
Super User II

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 to be a Super User!




View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

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 to be a Super User!




View solution in original post

Highlighted
Helper III
Helper III

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

Thank you @vanessafvg

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors