Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Week Ending Date DAX Column

Hello,   Hopefully this is an easy one. I have the following column in my date table, which I use to calculate the last day of the week for each row: End of Week = VAR DayNumberOfWeek = WEEKDAY(...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column formula should work

    ='Date Table'[Date] + (7 - WEEKDAY('Date Table'[Date],2))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

This calculated column formula should work

='Date Table'[Date] + (7 - WEEKDAY('Date Table'[Date],2))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Perfect, thanks. Much simpler than my previous formula, which I adapted from forumula to get week start date, that I found in a blog post somehere.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    You are welcome.