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 tamerj1.

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!

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?