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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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.

Top Solution Authors