Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Length of time between bookings



I've got an issue i'm trying to solve and i'm not getting very far with it.


I have a table that contains a list of bookings, the date they booked, a unique id for each customer, and what they booked (+ other columns that aren't relevant to this question). What I'm trying to find out is for each customer the average length of time (in days/month/years) between the bookings they have made & then hope to roll that up by what they booked. Can anyone suggest a method of going about creating a measure to solve this? Thanks

Community Support
Community Support

Hi @LaurenceSD ,


Sorry I don't understand your requiremnt only based on your description. Would you please show us sample data and expected output?


Thank you for your support and understanding.


Best regards,

Dedmon Dai

Hi, @v-deddai1-msft thanks for offering to help. I've put some sample data into excel, the blue table is the data, so what I've got is a unique ID for each booking, the date of each booking, a unique id for each guest, the name of the hotel they booked, and name of the product group booked, as well as the name and product group that was their very first booking.


The orange table shows the bookings for one guest and the length of time between each booking, in days, then at the bottom for that guest the average length of time, in days between each booking. This is what I'm wanting to replicate in PBI, so that ideally I can roll it up by Hotel and see if one hotel produces more frequent bookings than another hotel, does this make more sense now?




Hi @LaurenceSD ,


Would you please show the excel file instead of screenshot to us?


Best regards,

Dedmon Dai

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors