Getting YTD value instead of SAMEPERIODLASTYEAR

[eduardoa]

Hello,

Need to show the Same Period Last Year from a measure, but  the result shows the Year To Date value.

LYTD =

CALCULATE([my measure ],

SAMEPERIODLASTYEAR(DimDates[Date]))

Already tried this basic formula and many variations using PARALLELPERIOD,  DATEADD, etc. but the result allways shows YTD instead of SPLY.

Will appreciate any suggestion.
Thanks beforehand

[rubayatyasmin · Accepted solution]

Hi, @eduardoa 

Meaning,  today's date is August 2nd, 2023, then the SAMEPERIODLASTYEAR function returns dates from January 1, 2022, to August 2, 2022, hence why it looks like a YTD calculation.

* Do you want to calculate [my measure] for the complete previous year? then use DATEADD 

* if you want to calculate [my measure] for the complete previous year till today's date, use DATESYTD with DATEADD. 

for example. 

DATESYTD( DATEADD(DimDates[Date], -1, YEAR) )

this would calculate [my measure] for the period from jan 1, 2022, to aug 2, 2022 as today is aug 2, 2023. 

refer: https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

https://learn.microsoft.com/en-us/dax/dateadd-function-dax

https://learn.microsoft.com/en-us/dax/datesytd-function-dax

see if this thread helps you

Solved: SAMEPERIODLASTYEAR() - Microsoft Fabric Community

[rubayatyasmin · Accepted solution]

Hi, @eduardoa 

Meaning,  today's date is August 2nd, 2023, then the SAMEPERIODLASTYEAR function returns dates from January 1, 2022, to August 2, 2022, hence why it looks like a YTD calculation.

* Do you want to calculate [my measure] for the complete previous year? then use DATEADD 

* if you want to calculate [my measure] for the complete previous year till today's date, use DATESYTD with DATEADD. 

for example. 

DATESYTD( DATEADD(DimDates[Date], -1, YEAR) )

this would calculate [my measure] for the period from jan 1, 2022, to aug 2, 2022 as today is aug 2, 2023. 

refer: https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

https://learn.microsoft.com/en-us/dax/dateadd-function-dax

https://learn.microsoft.com/en-us/dax/datesytd-function-dax

see if this thread helps you

Solved: SAMEPERIODLASTYEAR() - Microsoft Fabric Community

[eduardoa · Accepted solution]

Hello @rubayatyasmin 

Thanks so much for your help!