The problem is that my "DayofWeek" is a calculate dimension: DATENAME('weekday',[Date])
Is there another way?
1 of 1 people found this helpful
You don't need to use a calculated dimension here as the pill set out as above does your exact purpose. Try that and it should work.