Calculating bookings based on booking date

[stampgeorge]

Hello!

I want to create a line graph that shows the bookings made for the last year based on today and compare it with the bookings this year, per month.

Basically, I want two lines, one with this years bookings made until today (which is easy), and a second one showing last year booking nr. by month where the bookings were made this day last year.

I have this for now:

LY Resv = 
CALCULATE(
    COUNTROWS(Reservations),
    Reservations[Arrival] = DATESBETWEEN('Date'[Date],DATE(YEAR(TODAY())-1,1,1),DATE(YEAR(TODAY())-1,12,31)),
    Reservations[Booked_Date] <= DATE(YEAR(TODAY())-1,TODAY(),TODAY()))

But it doens't work because it requires a T/F statement instead of datesbetween.

Thank you!

[DataInsights]

@stampgeorge,

DATESBETWEEN returns a table, so try using IN:

LY Resv =
CALCULATE (
    COUNTROWS ( Reservations ),
    Reservations[Arrival]
        IN DATESBETWEEN (
            'Date'[Date],
            DATE ( YEAR ( TODAY () ) - 1, 1, 1 ),
            DATE ( YEAR ( TODAY () ) - 1, 12, 31 )
        ),
    Reservations[Booked_Date]
        <= DATE ( YEAR ( TODAY () ) - 1, TODAY (), TODAY () )
)