Display Data by Week day - ie Mon, Tue etc

[MR]

Hi 

I need to sum multple event hours which happen on a given day of the week during a set time period.

For instance, I want to see the sum of events hours over a month in columns Monday, Tuesday, through to Sunday. This is to see the supply or demand on a given day of the week.

How can I sum a these hours by week days?

Any ideas?

Matt

[Anonymous]

Doesn't seem to work for DAX.  "Function 'FORMAT' is not allowed as part of calculated DAX expressions on DirectQuery models."

---

[akayuche]

Expression.Error: The name 'FORMAT' wasn't recognized. Make sure it's spelled correctly.

[Phil_Seamark · Accepted solution]

Just add a column to your data table, or to your Date table along these lines

Weekday = FORMAT(Dates[Date],"DDDD")

And then just drag that column to the axis of your visual.

[coolbreeze]

Nope. Does not work. I just get this error over and over "Cannot find table 'Dates'."

[CGodfrey]

In my case this did not work. To correct I removed the table reference:

Day of Week Short Name = FORMAT([Date],"DDD")
Output= Mon, Tue, Wed, etc. 

[S4m33r]

Brilliant! Yet simple

[GetITDone]

this does not work,  I copied and pasted get too many arguments

[charleshale]

Or in Power Query:

#"Day of Week" = Table.AddColumn(#"__prior command name__", "__desired new column name__", each Date.DayOfWeekName([__column referencing__], "en-US"), type text)
in
#"Day of Week"

[mfbati]

Hi

Is it possible to return short names of weekdays in Power Query?

(In DAX it is possible with FORMAT function)

[Anonymous]

This also works as part of the addcolumn query when building the Date Table.

For Example: 
Date =
ADDCOLUMNS (
CALENDAR (DATE(2000,1,1), DATE(2025,12,31)),
"Weekday", FORMAT([Date], "DDDD")
)

[MR]

Excellent, thanks Phil

M