Forum Discussion
SAMEPERIODLASTYEAR not working for old database
Hi, I'm going through this tutorial but I'm having trouble using SAMEPERIODLASTYEAR on a table where the latest date is from 3 years ago. The tutorial recommned using: Total Units: Total Unit...
Did you relate your date columns properly?
SAMEPERIODLASTYEAR doesn't know the actual year, and it doesn't how far your data goes back.
Is your date Table contigous and goes back far enough?
Best regards.