Forum Discussion

Pastrupgaard's avatar
Pastrupgaard
Helper I
8 years ago
Solved

problem with sameperiodlastyear

Hi guys

 

I've created YTD in the following period 01/01 --> 10/27 with the following formula, but I'm having trouble with incorporating the sameperiodlastyear formula in it:

 

Actual YTD ($) =  TOTALYTD (sum(f_sales[Actual ($)]) ; d_time[calender_date] ; DATESBETWEEN(d_time[calender_date] ; "01/01";"10/27"))

 

I've also postet a picture, since it's easier to see


I appreciate any ideas of how to get the same periodlastyear

 

Thanks in advance

  • Pastrupgaard's avatar
    Pastrupgaard
    8 years ago

    I got it to work with Calculate instead of TOTALYTD. Not sure what the difference is, but it works :)

     

    Thanks for the help

     

5 Replies