problem with sameperiodlastyear

[Pastrupgaard]

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

[Zubair_Muhammad]

Hi @Pastrupgaard

Try wrapping Datesbetween with sameperiodlastyear

SAMEPERIODLASTYEAR (DATESBETWEEN (_________))

[Pastrupgaard]

Hi @Zubair_Muhammad

For some reason. it's not possible to have both the sameperiodlastyear and datesbetween in the same formula 😞

Br
Pastrupgaard

[Zubair_Muhammad]

@Pastrupgaard

Remove the last bracket please

I see a Red ")" in the image you posted

[Pastrupgaard]

Hi @Zubair_Muhammad

My bad 🙂

I've corrected the formula, but there is no data output... I've recreated the data with a stupid workaround (so i know the data is there) and now i'm trying to make it smarter with this formula.

Any smart ideas?

Br
Pastrupgaard

[Pastrupgaard · Accepted solution]

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

Thanks for the help