Forum Discussion
Current Year vs Previous Year
You must use SAMEPERIODLASTYEAR() instead of PREVIOUSUEAR(), because the last one returns ALL dates from the last year, and you need the same day shifted one year back (Using SAMEPERIODLASTYEAR()).
Regards!
Hello Johanno
Thank you for the suggestion, but it does not work.
First Case
Second Case
In the First Case no value is showed, while in the Second Case it returns the total of the previous year basing on the year of the Date field.
For each day of the Date field, it should return the Amount of the same day in the previous year.
Regards
Lino
Resolver IIIYou must use SAMEPERIODLASTYEAR() instead of PREVIOUSUEAR(), because the last one returns ALL dates from the last year, and you need the same day shifted one year back (Using SAMEPERIODLASTYEAR()).
Regards!