Same Period Last Year for any random period (12.3.2018 - 4.2.2019 -> 12.3.2017 - 4.2.2018)

[herbemischung]

Hi,

once again, I have a task that I thought was easy and still can't get any further.

I have a slicer where I can enter any start and ending date.

Most of the time I want to know all sales data from fall to spring compared to the same period -1Year.

I used the measure: AJ = Sum(Salesdata[Sales]) and VJ = calculate([AJ];SAMEPERIODLASTYEAR(Salesdata[Date].[Date]))

I also tried Dateadd -1

Every time I got the same sales Amount AJ and VJ.

What am I doing wrong here?

[amitchandak · Accepted solution]

Are your dates continuous? Also, use the date dimension instead of the sales table date.

You can also try

calculate([AJ];dateadd(Date.[Date],-1,year))

[herbemischung]

Thanks, I had to add a time-table. It now works as I hoped it would!

all the best

herb