Forum Discussion

Tlotly's avatar
Tlotly
Icon for Helper V rankHelper V
4 years ago
Solved

Week Start for the following week

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
Need Help
  • Seanan's avatar
    Seanan
    4 years ago

    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.

2 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    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.