Forum Discussion

Kray's avatar
Kray
Helper I
8 years ago
Solved

SAMEPERIODLASTYEAR Function Lack

Hello,    I use this function very well but there is a lack , if the product was not sold on current month-week-year yet you cant see the last year sales. how can I see the last year data within th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Kray，

    Change the SamePeriodLastYear measure to the following, you will get value in Feb.

    SamePeriodLastYear = CALCULATE([sale],SAMEPERIODLASTYEAR(TAKVIM[Date]))


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Kray，

Change the SamePeriodLastYear measure to the following, you will get value in Feb.

SamePeriodLastYear = CALCULATE([sale],SAMEPERIODLASTYEAR(TAKVIM[Date]))


Regards,
Lydia

Kray's avatar
Kray
Helper I
8 years ago

So great, it works now :) Thank you Dear Lydia.