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 

you may try

Net_Sales_SPLY =
CALCULATE (
    SUM ( 'Table'[SalesAmt] ),
    SAMEPERIODLASTYEAR ( 'CalendarTable'[Date] ),
    CROSSFILTER ( 'Table'[Date], 'CalendarTable'[Date], 3 )
)
  • 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