Try using DATEADD instead of SAMEPERIODLASTYEAR. Here is one of Sam’s videos that explains this concept.
