Forum Discussion

StephenK's avatar
StephenK
Icon for Resolver I rankResolver 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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

StephenK , you to remove bi-directional join as that is causing date in date dimension also getting filtered.

Make it only one-directional 1- Many from date to Data table