Custom week in Power BI

[Syndicate_Admin]

Hello. I'm trying to create custom weeks in Power Bi, but depending on the schedule. I need my week to start on Monday at 08:00 AM and end next Monday at 07:59 AM.

In this way, for example, week 33 would be from Monday, August 15 at 08:00 AM to Monday, August 22 at 07:59 AM.

I hope you can help me.

Best regards

Sergio

[lbendlin]

Take your transaction datetime stamps, shift them back by 8 hours, and then apply the standard week functions.