Forum Discussion

rickylee's avatar
rickylee
Helper III
8 years ago

SAMEPERIODLASTYEAR does not work as expected

Hello, I am trying to use the SAMEPERIODLASTYEAR formula but it seems it does not work as it is.  Last year revenue2a = CALCULATE(sum('Revenue 2017 18'[Total]),SAMEPERIODLASTYEAR('Calendar'[Date]...
Need Help
rickylee's avatar
rickylee
Helper III
8 years ago

*I have posted the following before but it did not exist in my subscription. So I re-post again.

 

Hello,

I am trying to use the SAMEPERIODLASTYEAR formula but it seems it does not work as it is. 

Last year revenue2a = CALCULATE(sum('Revenue 2017 18'[Total]),SAMEPERIODLASTYEAR('Calendar'[Date]))

 

 

The relationship between 'Calendar' table and 'Revenue 2017 18' can be seen below:

powerbi relationship.png

 

The calendar table has one formula only: 
Calendar = CALENDARAUTO(3)

table - calendar.png

The 'revenue 2017 18' table has 12 rows of data only:
table - revenue 2017 18.png

 

When I try to display the thidd column which has the formula:
"Last year revenue2a = CALCULATE(sum('Revenue 2017 18'[Total]),SAMEPERIODLASTYEAR('Calendar'[Date]))"
The column displays data in 2019 which I don't have such data at all. 
output.png

 

Did I do anything wrong?

Thanks,
Ricky

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi rickylee,

    Could you have received the reply I sent to you before? And have you tetsed to modify your calendar table like this?

    Table = CALENDAR("2017/1/1","2018/12/31")

     

     

    Regards,

    Daniel He