How to Create Custom Weekly Periods?

[ERing]

I have a simple report to show Sales Revenue by Week. My model constists of a Fact table (Metrics) and a Calendar table. 

My end users have asked for a way to analyze the data using custom 7 day weekly periods. So I need the ability to create custom 7 day weekly periods where the first date is any date I choose (could be 1/1/2025, 1/2/2025, 1/3/2025, etc)

Additionally, the end users have requested that they be able to select the first date that creates the 7 day weekly periods (rather than relying on me to change the start date). They may initially choose 1/1/2025 which would set the weeks as Wednesday - Tuesday. Later, they may choose to a start date of 1/4/2025 which would set the weeks as Saturday - Friday.

So my specific requirements are:
1. Ability to create custom 7 day weekly periods (by me)

2. Ability to allow the end users to select the starting date in the custom weekly periods.

I'm not sure where to get started so any help is greatly appreciated! I've included sample data below.

SAMPLE POWER BI FILE 

[v-sgandrathi]

Hi @ERing,

Thank you @lbendlin for your response for the query.

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[lbendlin · Accepted solution]

At least one of these requirements is not necessary.

[ERing]

It seems I should have been more thorough in my example. My apology. I was anticipating that the solution would include adding a "Start of the Week" to the Calendar table with some provision allowing the end users to enter the first date.

Here is a more thorough explanation of what I'm looking to accomplish.

I have several measures that I need to be able to display in a table visual with a slicer for the start of the week.

The minimum requirement is that I'm able to create weeks with any start date I choose (could be 1/1/2025, 1/2/2025, or even 1/17/2025).

The preffered requirement would be that my end users can select the start date for the custom week periods on thier own with out me having to manually update the report.

The goal output would be like this, with a slicer on start of the week.

Updated Sample Power BI File 

[lbendlin]

You may find that my proposed approach is ultimately providing what you need, and is cleaner. There is no need to specify a particular date as the beginning of the week, and  there is no point in trying to make that a calculated column (you can't create a calculated column from a slicer selection).