Sales Last year and cumulative Sales not working


#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


#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:


#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


#6

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