1 of 1 people found this helpful
I'm not sure I completely understand the desired outcome. Do you want Weekday to be it's own column? One way to get weekday in a calculated field is to use something similar to the following:
datename('weekday', [Order Date])
Not sure if this helps at all
The only reason I can think of for that calculation to be an error is if the datatype of [Order Date] is not a date or datetime (I can't see that field in the fields list on your screenshot). Is [Order Date] a date data type?
See screenshot when I use the Coffee Chain data:
Does that help?
This was exactly what I needed. Thank you!