Forum Discussion

StephenK's avatar
StephenK
Resolver I
6 years ago

SAMEPERIODLASTYEAR expects a contiguous selection

Hello all,   I have the following measure:  Dynamic Capacity SPLY = CALCULATE(SUM('Fact_Schedule'[DynamicAdjustedSlots]),SAMEPERIODLASTYEAR('Date Dim'[Date]))-[DynamicPTO] I'm getting the foll...
Need Help
bsphil's avatar
bsphil
New Member
2 years ago

This is a very late response but I just resolved a near identical issue and felt it should be documented.

 

The problem is actually the bidirectional filter on your Holidays and COVID19_Schedule tables that connect to your Date table, even though those tables aren't necessarily involved in the calculation. Being a one-to-one relationship forces bidirectional filtering, so switch that to be a many-to-one relationship so you can mark the cross filter direction as single.

 

I had a very similar situation with a holiday table connecting to a date table:

 

 

Measures using SAMEPERIODLASTYEAR failed until I made this minor change, now those measures calculate properly:

 

 

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Thank you so much for your help! With this I discovered the problem I had in a model that was not doing the calculation for me