SAMEPERIODLASTYEAR()

Question

Hi&nbsp;I have created a measure as below which gives me the total sales from the 1st April&nbsp;up to today&nbsp;TOTALSALES = CALCULATE(SUM(SALES[LINEAMOUNT]),&nbsp;&nbsp;&nbsp; FILTER(SALESLINE,SALESLINE[Depot] = "Depot 1"),&nbsp;&nbsp;&nbsp; DATESBETWEEN(SALESLINE[DELIVERY DATE],&nbsp;&nbsp;&nbsp;&nbsp; DATE(2018,4,1),&nbsp;&nbsp;&nbsp;&nbsp; TODAY()&nbsp;&nbsp; ))&nbsp;Then I want to get the same sales from the exact period last year so have created a further measure&nbsp;LY SALES = CALCULATE([TOTALSALES],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SAMEPERIODLASTYEAR('DATE'[Date]))&nbsp;I cannot figure out why it won't work!! I am sure the SAMEPERIODLASTYEAR is the correct function but it won't give me any result.&nbsp;Any help would be appreciated.

v-jiascu-msft · Accepted Answer

Hi&nbsp;Qualube,
&nbsp;
The SAMEPERIODLASTYEAR needs a Date context. But the previous measure can't provide that. How did you use the measure? Please try the measure like below.
&nbsp;
TOTALSALES =
CALCULATE (
    SUM ( SALES[LINEAMOUNT] ),
    FILTER ( SALESLINE, SALESLINE[Depot] = "Depot 1" ),
    DATESBETWEEN (
        SALESLINE[DELIVERY DATE],
        DATE ( 2017, 4, 1 ),
        EDATE ( TODAY (), -12 ) // "today" of last year.
    )
)

&nbsp;
Best Regards,Dale

Forum Discussion

SAMEPERIODLASTYEAR()

2 Replies

Related content

SAMEPERIODLASTYEAR()

Issue with SAMEPERIODLASTYEAR and Manual Time Intelligence

SAMEPERIODLASTYEAR is blank

Need Urgent Help on SamePeriodLastYear

SAMEPERIODLASTYEAR not giving correct results