This content has been marked as final. Show 4 replies
Hi all! I've found a calculation for separating out the date field in my workbook into "Weekend" and "weekday" as follows:
DATENAME('weekday', [Date]) = "Saturday"
OR DATENAME('weekday', [Date]) = "Sunday"
But I'm hoping to remove Friday data from the weekday (and weekend) since Fridays are atypical and problematic for showing weekday averages. How would I append the above calculation to exclude "Friday" from "weekday"?
Thanks for any help you can provide.