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.

pdamac's avatar
pdamac
New Member
8 years ago

Dear friends, unfortunately this function has no solution if there is an error. It is the worst function of Power BI, because it is necessary but only works in an unknown condition and does not work in others. It's a pity that this happens in an excellent solution like Power BI. There will be no solution. If it works, use it if you do not use any other function. That's the truth.