Forum Discussion
Total Sales Last Year
Hello All, I have a question that I have seen on here multiple times, however I am having an issue that I have not seen. I have created a measure to display 'Last Years Sales' using the followin...
Thank you so much for your reply!! I have my measures as so:
Total Sales = SUM(IHeads[Sales])
Total Sales LY = CALCULATE(SUM('IHeads'[Sales]), PREVIOUSYEAR('Calendar'[Date]))
% Chg vs LY = DIVIDE([Total Sales]-[Total Sales LY],[Total Sales LY])
The only one that is not working is the Total Sales Last Year
I have also tried:
Total Sales LY = CALCULATE([Total Sales], PREVIOUSYEAR('Calendar'[Date]))
Total Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Calendar'[Date])) - gives me contiguous date error
I am facing the exact same problem its returning the same figures as the current year did you ever solve this at all?