Forum Discussion
SAMEPERIODLASTYEAR Issues
I tried solving my issue by reviewing other post on this topic but I seem to be stuck. I am unable to get the SAMEPERIODLASTYEAR function to work for me. Any help would be greatly appreciated. ...
You can Try below DateYTD or Total YTD
Last Year YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date Filer],-12,MONTH)))
Also in one calculation, you are passing data[date] another one calendar date. Just check the join is correct.