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
DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I ran into a similar issue. Is your Date Dim a calculated table in Power BI that is getting the start/end dates from another table?