Week Start for the following week

[Tlotly]

Hi Team

I need to create a week start date for the 2 weeks after the current one. It should start on a Monday

Below is DAX for current week start:

WeekStart_Monday_01 = TODAY() - WEEKDAY(TODAY(),1)+2

Basically the results should be: 04 July 2022

Thank you

Matlotlo

[Tlotly]

@Seanan thank you. Got it😊

[Seanan · Accepted solution]

Hi @Tlotly 

You could create a simple measure that adds 14 days onto your current weekstart measure

WeekStart02 = 'Table'[WeekStart_Monday_01] + 14

This would return 04/07/2022 and will always return the date 2 weeks after weekstart01 date.