Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SamePeriodLastYear

Hello,   I have a measure -- Net_Sales_SPLY = Calcuate(Sum('Table'[SalesAmt]), SAMEPERIODLASTYEAR('CalendarTable'[Date])) and get the following error every so often. Not able to fully understand ...
DATEADD
Sameperiodlastyear
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks amitchandak.

It is not breaking any more, but the numbers don't seem right.

I should have mentioned earlier that the date in the Table[Sales Amt] is a week ending date, and the date in the Calendar table is a daily date.  Not sure if this matters or not.

Thanks again!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , the Same week can fall in a different month. Unless you have 445 calendar. But based on weekend date falling in month total should be correct