2 Replies Latest reply: May 14, 2015 5:38 AM by Anupam Singh RSS

    Calculating Date within Range of Dates

    Harrison Chisonga

      Gurus,

      I have a Date Table with field WeekStartDate and my Fact Table with field DateOfSale. I want to compare sum of sales for this week (Week-To-Date) with sales for previous week (TOTAL Previous Week).

       

      Kindly assist