Forum Discussion
Solved
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, Tuesda...
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.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeJust 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.
charleshale
Continued Contributor
Continued ContributorOr 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"
Hi
Is it possible to return short names of weekdays in Power Query?
(In DAX it is possible with FORMAT function)
