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:



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

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


      THEN "Weekend"

      ELSE "Weekday"



      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.