Forum Discussion
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
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.
11 Replies
- Phil_Seamark
Microsoft Employee
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.
Excellent, thanks Phil
M
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.
Expression.Error: The name 'FORMAT' wasn't recognized. Make sure it's spelled correctly.
