You could create a calculated field as a dimension to do this.
Might get a little dicey if you involve multiple years, but should work for a single year at least...
IF Datename('weekday',[ETLDate]) = 'Sunday'
//note that [ETLDate] was the date field from my data
Hope this helps!
This worked, thank you!