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
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Would you please share a screenshot of your table visual?

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?