Home Forums Data Warehousing PowerPivot How to calculate 6 weeks sales prior to starting of fiscal year RE: How to calculate 6 weeks sales prior to starting of fiscal year

  • April 5, 2016 at 8:09 pm

    #1870033

    I think it would be something along the lines of

    CALCULATE ( [Total Sales],

    DATESBETWEEN(DATEADD("week",-6,Calendar[Date]),Calendar[Date]) )