Forum Discussion

powerlight1's avatar
powerlight1
Icon for Helper I rankHelper I
9 months ago
Solved

Create Week Start date column within a date table

Hi community,   I have a table with a date column and I am trying to create a new column that is Week_Starting (Monday).  I have already created the Week Num and Day of Week columns and I wanted to...
"DAX "
Startofweek
  • MasonMA's avatar
    MasonMA
    9 months ago

    Hi,

     

    If your DATE_LYSLS is continuous and there is no missing date, try this for a new column

    WeekStart = [DATE_LYSLS] - (WEEKDAY([DATE_LYSLS], 2) - 1)

     

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
9 months ago

Hi,

 

If your DATE_LYSLS is continuous and there is no missing date, try this for a new column

WeekStart = [DATE_LYSLS] - (WEEKDAY([DATE_LYSLS], 2) - 1)