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

Kray's avatar
Kray
Helper I
8 years ago

Check my now and last numbers on pic you will see same number(Second order in 2017 and first order in 2016)

I think the lack is this function's operating logic . It compares current data with last data , if current data is absent function cant compare so it shows zero . You can try it with your data 

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.