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

[irnm8dn]

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" ),

"Year", YEAR ( [Date] ),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

"MonthShortYear",FORMAT([Date], "mmm-YYYY"),

"MonthNameShort", FORMAT ( [Date], "mmm" ),

"MonthNameLong", FORMAT ( [Date], "mmmm" ),

"DayOfWeekNumber", WEEKDAY ( [Date] ),

"DayOfWeek", FORMAT ( [Date], "dddd" ),

"DayOfWeekShort", FORMAT ( [Date], "ddd" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),

"Week Number", WEEKNUM ( [Date] ),

"Week Number and Year", "W" & WEEKNUM ( [Date] ) & " " & YEAR ( [Date] ),

"WeekYearNumber", YEAR ( [Date] ) & 100 + WEEKNUM ( [Date] )

)

I'd like to add a column that shows a "week ending" date formatted as mm/dd/yyyy so that I can aggreagte information by week ending date.  Typical week Sunday thru Saturday.

**Also, if someone has a more useful direction to create a DateDim table, I am all ears.

Appreciate all of the help.

[parry2k]

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

[irnm8dn · Accepted solution]

@parry2k 

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

WeekEnding = 'Date'[Date]-MOD('Date'[Date]-1,7)+6

[parry2k]

@irnm8dn looks good.