Reply
MR Frequent Visitor
Frequent Visitor
Posts: 2
Registered: ‎03-01-2017
Accepted Solution

Display Data by Week day - ie Mon, Tue etc

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


Accepted Solutions
Highlighted
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Display Data by Week day - ie Mon, Tue etc

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post


All Replies
Highlighted
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Display Data by Week day - ie Mon, Tue etc

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

MR Frequent Visitor
Frequent Visitor
Posts: 2
Registered: ‎03-01-2017

Re: Display Data by Week day - ie Mon, Tue etc

Excellent, thanks Phil

M

Frequent Visitor
Posts: 9
Registered: ‎04-30-2018

Re: Display Data by Week day - ie Mon, Tue etc

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

Regular Visitor
Posts: 18
Registered: ‎04-05-2018

Re: Display Data by Week day - ie Mon, Tue etc

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"