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.
Doesn't seem to work for DAX. "Function 'FORMAT' is not allowed as part of calculated DAX expressions on DirectQuery models."
Expression.Error: The name 'FORMAT' wasn't recognized. Make sure it's spelled correctly.
