Forum Discussion
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.
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.
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.
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")
)- charleshale
Continued Contributor
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"Hi
Is it possible to return short names of weekdays in Power Query?
(In DAX it is possible with FORMAT function)
this does not work, I copied and pasted get too many arguments
Brilliant! Yet simple
Nope. Does not work. I just get this error over and over "Cannot find table 'Dates'."
