brawnystaff
Board Regular
- Joined
- Aug 9, 2012
- Messages
- 104
- Office Version
- 365
I am using Excel 2016 Pivot tables/Data Model option and am trying to insert a DAX measure to get the day of the week for a date. The formula should be
but when I try it I get an error message.
I know if works in Power Pivot that way, but not working in the 2016 Pivot Table as a measure. Any ideas as to what the problem is? Thanks.
Code:
=Format([Date],"DDDD")
I know if works in Power Pivot that way, but not working in the 2016 Pivot Table as a measure. Any ideas as to what the problem is? Thanks.