SAMEPERIODLASTYEAR not working.

[Fusilier]

Hi,

Trying to create a DAX command using this function.

My data is as follows:

The Month column is formatted as Date.

If I take out the SAMEPERIODLASTYEAR element it returns the value for the current month OK. But as soon as I add in SAMEPERIODLASTYEAR it returns a blank field.

Can anybody see what I'm doing wrong here?

[Fusilier]

Apologies, my fault. Solution 2 works like a dream!

THANK YOU!

[FreemanZ · Accepted solution]

hi @Fusilier 

try like:

Prev Year = 
CALCULATE(
    SUM(data[Incident]),
    FILTER(
        ALL(data),
        data[month]=EDATE(EARLIER(data[Month]), -12)
    ),
    ALLEXCEPT(data, data[Location])
)

or 

Prev Year2 = 
SUMX(
    FILTER(
        data,
        data[month]=EDATE(EARLIER(data[month]), -12)
            &&data[location]=EARLIER(data[location])
    ),
    data[Incident]
)

it worked like: