Forum Discussion

RevenNic's avatar
RevenNic
Frequent Visitor
6 years ago

Comparative booking pace

Hi Guys,   I am trying to build a measure that can reference bookings placed for a particular month in comparison to bookings placed in the same period last year, for the same arrival month last ye...
Need Help
Tips and Tricks
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi RevenNic ,

Not certain what is your expected value to calculate, the same period last year revenue based on booking placed date?

If so, try like this measure:

Same Period Last Year =
CALCULATE (
    SUM ( 'Table'[revenue] ),
    SAMEPERIODLASTYEAR ( 'Table'[booking placed] )
)

If not, could you please share more details or expected output for further discussion?

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

RevenNic's avatar
RevenNic
Frequent Visitor
6 years ago

Hi v-yingjl 

 

Thank you for trying, formula didn't work. I think it's because I have so many date columns.

 

My date table is connected to <arrival date> in my bookings table.

 

Other dates in my table are:

<date placed>

<date cancelled> only has data when a booking is cancelled

<departure date>

 

I want to see TOTAL REVENUE that was booked during a <date placed> date range for an <arrival date> date range and compare it with same time last year over both ranges.

 

So:

 

Revenue for bookings that were <date placed> 1-may-2020 - 13-may-2020 which are <arrival date> 1-june-2020 - 30-june-2020

 

Compare in a second column revenue for bookings that were <date placed> 1-may-2019 - 13-may-2019 which are <arrival date> 1-june 2019 - 30-june-2019

 

And same for 2018, 2017 etc..

 

Hope that helps.