Cy vs PY

[WernerDC]

Hi Guys, how do I write this formula to show the previous years data? This is my current year selection. I want to show how the data looked exactly the same time last year.

[MuhammadFahim · Accepted solution]

You can use Addyears function in your vDateStart and vDateEnd.

Addyears(vDateStart,-1)
Addyears(vDateEnd,-1) 

it will return the start and end dates of  the same period of last year

[WernerDC]

Thank you

[MayilVahanan · Accepted solution]

HI @WernerDC 

Instead of If condition, Try with set analysis like below

sum({<dateEntry_det={">=$(=AddYears($(vDateStart),-1))<=$(=AddYears($(vDateEnd),-1))"}, serviceCode_det={30}>}qtyHa_det)

[WernerDC]

Thank you