3 Replies Latest reply on Sep 10, 2018 11:22 AM by Shinichiro Murakami

    How To Exclude Weekend and Holiday only for Day and Include it while grouping by Month

    susheela.hegde

      Hi All,

       

      I have to exclude the Measures for weekend when I select the Parameter Day and Yesterday but include the values when we select anything other than day or yesterday.

       

      I am able to exclude the weekend by below calculation:

       

      IF (DATENAME('weekday',[Order Date])='Saturday' OR

      DATENAME('weekday',[Order Date])='Sunday' )

      THEN '1' ELSE '0' END

       

      How ever, this filter eliminates the values even while grouping by month or week .

      How to exclude only for days and have the weekends included for rest of the aggregation?