SAMEPERIODLASTYEAR() returns incorrect result when current day is selected

[Anonymous]

Hello, 

I'm strugling with calculation of last year's bookings. I'm using the function SAMEPERIODLASTYEAR, but for some reason when current day or some future date is selected, it returns value of bookings for whole month (picture attached). When I choose yesterday's date, calculation is correct - it takes only same part of last year's month.

I was trying to put in the formula additional filter that limits my table 'Date - bookings' to today()-1, but without any good results. 

Has anybody experienced same issue?

Thank you for any suggestions.

Bookings USD =  SUM(contract_data[price])

Prior Period =

CALCULATE([Bookings]                                        

                    ,SAMEPERIODLASTYEAR('Date - bookings'[Date])

                    )

The Date table is calculated, relationship is 1:N and one-way:

Date - bookings =

ADDCOLUMNS (

                   CALENDAR (MIN(contract_data[booking_date]), TODAY()),

                   "Year/Month", FORMAT ( [Date], "YYYY/MM" ))

[Anonymous]

Do you have a dedicated date table? If so, is it marked as such?  

[Anonymous]

Hi, thanks for your reply. Yes it is marked as date table. It is calculated table as noted in my post above.

[Anonymous]

can you upload some sample data?

[Anonymous]

Hi, 

the file is here: https://gofile.io/?c=459T1J

Thanks

[Anonymous]

it's working like it is supposed to. Everything comes down to context. So when you have a date slicer that stops before the current end of the month, it will give you the total of the previous period of that same time.