4 Replies Latest reply on Aug 8, 2016 1:12 PM by pooja.gandhi

    Define weekend and weekday excluding one specific day

    Melissa Fanucci

      Hi all! I've found a calculation for separating out the date field in my workbook into "Weekend" and "weekday" as follows:

       

      IF

          DATENAME('weekday', [Date]) = "Saturday"

      OR DATENAME('weekday', [Date]) = "Sunday"

       

      THEN "Weekend"

      ELSE "Weekday"

      END

       

      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.

       

      Melissa