Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Including Week Ending Column in Date Table- DAX Help!!!

I am currently using the following DAX statement to create a date table...   Date = ADDCOLUMNS ( CALENDAR (DATE(2000,1,1), DATE(2025,12,31)), "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ), "Ye...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    parry2k 

     

    Found this elsewhere - seems to do the trick.  Any thoughts?

     

    WeekEnding = 'Date'[Date]-MOD('Date'[Date]-1,7)+6
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous check this link, in comment there are many calculation to get weekend date.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k 

 

Found this elsewhere - seems to do the trick.  Any thoughts?

 

WeekEnding = 'Date'[Date]-MOD('Date'[Date]-1,7)+6
  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous looks good.