cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaurenceSD
Helper II
Helper II

Length of time between bookings

Hi,

 

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

3 REPLIES 3
v-deddai1-msft
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?

 

LaurenceSD_0-1624607763351.png

 

Hi @LaurenceSD ,

 

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

 

Best regards,

Dedmon Dai

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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