Issue with SAMEPERIODLASTYEAR in Enhanced DAX Time Intelligence (Preview) Week 53 returns incorrect

Hi bpratyusha ,

Please try below two options for LY measure.

1. Your table is DimDate, but the Enhanced Calendar object is called Date(454). However OFFSET must always reference DimDate, NOT the name of the calendar object.

LY Sales =
CALCULATE(
SUM('fact'[sales]),
OFFSET(
-1,
ORDERBY(DimDate[fiscal_day_in_year]),
MATCHBY(DimDate[fiscal_year]),
DEFAULT
)
)

2. LY based on fiscal_year – 1 + same fiscal_day_in_year.

LY Sales =
VAR CurrentFiscalYear =
SELECTEDVALUE ( DimDate[fiscal_year] )

VAR CurrentFiscalDay =
SELECTEDVALUE ( DimDate[fiscal_day_in_year] )

VAR TargetFiscalYear =
CurrentFiscalYear - 1

RETURN
CALCULATE (
SUM ( Fact[sales] ),
KEEPFILTERS (
FILTER (
ALL ( DimDate ),
DimDate[fiscal_year] = TargetFiscalYear
&& DimDate[fiscal_day_in_year] = CurrentFiscalDay
)
)
)

Your DatePeriod slicer breaks LY because of bidirectional relationships. Use SINGLE-direction relationship instead of bidirectional relationships.

Cross filter direction, Single (DatePeriod --> DimDate)

DATEADD & SAMEPERIODLASTYEAR ARE NOT SUPPORTED for custom calendars. It is a limitation.  We would recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

https://ideas.fabric.microsoft.com/ideas/search-ideas/ 

Some members havesubmitted ideas regarding SAMEPERIODLASTYEAR  function in ideas forum. Please refer below link, if any idea is related to your query please upvote the particluar idea.

Search - Microsoft Fabric Community

Thank you for being a valued member in Microsoft Fabric Community Forum

Regards,

Dinesh