Forum Discussion

powerlight1's avatar
powerlight1
Helper 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)

     

powerlight1's avatar
powerlight1
Helper I
9 months ago

hi community,

 

I tried rewriting the DAX statement by first creating a summarised table (_table1) and then use the summarised table to link back to the 'Period Filter' table using the Week_Num columns and return the Date column in the _table1.  However you can see I got an error message.

 

 

MasonMA's avatar
MasonMA
Super 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)