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,

I am not sure what fields you use to create the visual, could you please describe the fields in the visual.  And we also need to know that  if you get data in February when you use Year, MonthName fields and the measure to create visual.

Regards,
Lydia