Forum Discussion

aamoody81's avatar
aamoody81
Regular Visitor
8 years ago
Solved

SAMEPERIODLASTYEAR for only values in current year

Hi,   I'm trying to show the value from prior year for products. I only want the products that are present in the current year to show.      What I would like: Product SamePeriodSalesLastYear ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =IF([Sum of ProductSales]=0,BLANK(),CALCULATE([Sum of ProductSales], SAMEPERIODLASTYEAR(D_DATE[DATE])))

     

    Hope this helps.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Can't you just wrap that in an IF statement such that "if the sum of the sales in the current year is 0, then blank, otherwise, the calculation you mention"