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


      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?