Forum Discussion

whatisdata96's avatar
whatisdata96
Icon for Helper I rankHelper I
4 years ago
Solved

How to get Week START and Week END Date? Week Start = Saturday & Week End = Friday) in my date table

Hi all - question says it all.   I have a date table in my model. I need 2 columns. Week start = Saturday .. Week End Date = Friday.. If anyone could help, please provide DAX for this considering I...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, whatisdata96 

     

    You can try the following methods.

    Column:

    Weekday = IF(WEEKDAY('Date'[Date])<=6,WEEKDAY('Date'[Date])+1,WEEKDAY('Date'[Date])-6)
    Weeknum = CALCULATE(COUNT('Date'[Weekday]),FILTER('Date',[Weekday]=1&&[Date]<=EARLIER('Date'[Date])))
    Week Start = CALCULATE(MIN('Date'[Date]),FILTER('Date',[Weekday]=1&&[Weeknum]=EARLIER('Date'[Weeknum])))
    Week End = CALCULATE(MAX('Date'[Date]),FILTER('Date',[Weekday]=7&&[Weeknum]=EARLIER('Date'[Weeknum])))

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Week end date =date_column+(7-WEEKDAY(date_column,16))

Week start date =date_column-(7-WEEKDAY(date_column,16))