Sales Last year and cumulative Sales not working

DAX DAX Calculations
1

I am re-working the demo of the customer analysis
I have pulled in my own data to play around and test a few things

But my last year sales not calculating and also cumulative last year and 2 years back
Not sure what could be wrong?
is it possible for you to have a look?

I emailed you my pbix file

here some graphs attached

image
image.png1373×751 71.6 KB

2 
Sales LY = 
CALCULATE( 
	[Total Sales] , 
		SAMEPERIODLASTYEAR( 'Date'[Date] ))
3

Could be your relationships between the Sales & Dates Tables. Check to make sure your relationship looks like this:

image
image705×602 20.5 KB

Enterprise%20DNA%20Expert%20-%20Small

4

thank you for the reply. but its still doing the same?
Any other suggestions?

5

Looks like you are using same DAX calculation for Total Sales & Sales LY? Please paste your calculations for each so we can compare. Here is what each should look like.
image
image

Enterprise%20DNA%20Expert%20-%20Small

6

Highly recommend going through this entire workshop, it explains all the calculations in a progressive way.