Weekly Average

Hi M_SBS_6 

You can create below measure to store current week number .

Current Week number = WEEKNUM(TODAY())

Then divide your distinct measure by this number to arrive at avg booking per week as shown below.

Avg Booking per Week = CONVERT(
    DIVIDE([Distinct Bookings], //here you can put your measure name
                        [Current Week number]
)
,INTEGER
)

Try above solution and let me know.

Please give Kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

Hi M_SBS_6 

You’ll need a Calendar table with a column for the week number (WeekNum or WeekOfYear) based on your CreatedOn date.
Once you have that, you can create a measure like this:

Avg Bookings per Week =
DIVIDE(
[Bookings],
MAX('Calendar'[WeekOfYear])
)

This will divide the total number of bookings by the current week number (e.g., 43) to calculate the average bookings per week up to the current point in the year.
If you want the calculation to adjust automatically by year, make sure your Calendar table is filtered to the selected year.

If I didn’t fully capture your scenario, please share a sample file (without sensitive data) through a public link so it can be reviewed in context.

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