Forum Discussion
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
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
- Zubair_MuhammadCommunity Champion
Hi Pastrupgaard
Try wrapping Datesbetween with sameperiodlastyear
SAMEPERIODLASTYEAR (DATESBETWEEN (_________))- PastrupgaardHelper I
For some reason. it's not possible to have both the sameperiodlastyear and datesbetween in the same formula :(
Br
Pastrupgaard- Zubair_MuhammadCommunity Champion