Weekly Average

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