topic SAMEPERIODLASTYEAR not working. in DAX Commands and Tips

SAMEPERIODLASTYEAR not working.

Fusilier — Wed, 03 May 2023 16:02:30 GMT

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?

Re: SAMEPERIODLASTYEAR not working.

FreemanZ — Wed, 03 May 2023 17:10:00 GMT

hi Fusilier

try like:

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

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

it worked like:

Re: SAMEPERIODLASTYEAR not working.

Fusilier — Wed, 03 May 2023 18:29:57 GMT

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

THANK YOU!