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

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
Sorry I mean the report visual. Can you share the results you are getting? What are you slicing by in your report? The Date column from the calendar table or from the sales table?