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
StephenK's avatar
StephenK
Resolver I
6 years ago

v-deddai1-msft I've already checked that. Please see my previous screenshot for verification. I've looked into the workaround you suggested. I'm not finding a good application for it because I need my SAMEPERIODLASTYEAR measure to be visualized by month.

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