Only getting one day a week when adding Day of week number to calendar table

[smithD0]

I'm using the following formula to create a Date Table.  Everything shows up appropriately, until I add the Day of the week numbering, at which time, I only see Saturdays or Sundays.  I've created a new table that has dedicated column formulas for the day of the week entries, and that works without issue.  Is there something wrong with adding them all to a single calculated table that would only display a single day?

Calendar =
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" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", FORMAT(WEEKDAY ( [Date] ), "00"),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ))

[v-shex-msft]

Hi @smithD0,

Your formula seems well, it works on my side. Can you please share some detail about previous formula which caused the issue?

BTW, I don't think you can direct add one table to other one, current you can only use union function to combine tables and use one new table to store merged table.

Regards,
Xiaoxin Sheng

[smithD0]

It was related to how the data was formatting itself.  Once the date was sorted, things were back in order.

[v-shex-msft]

HI @smithD0,

Can you please explain more about this or share a reproduce sample file to test? I still can't reproduce your scenario on my side.

Regards,

Xiaoxin Sheng