rolling 3 years data

[Krish2459_58]

Hi,

I need to show data from today to next 3years same day. The dates are not continuous like there is no data for 02-01-2028.

I tried this

sum({<DateNum_Eve= {">$(=today()) <$(=Addmonths($(vTodaysDateNum),36))"}>} [sales])

Thanks..

[Clement15]

Hello,
You can use this :

sum({<DateNum_Eve= {">$(=today()) <$(=Addmonths(today(),36))"}>} [sales])

Even if the date is not in your model it should not pose a problem for the inferiority criterion.

[Krish2459_58]

Hi Any suggestions please..

[Kushal_Chawda]

@Krish2459_58  try addyears

sum({<DateNum_Eve= {">$(=today()) <$(=AddYears(today(),3))"}>} [sales])