Calculating a rolling 52 for qty shipped

[Igotzepowerbi]

Hi,

I need to get a rolling 13 for quantity shipped. 

I have this for my units shipped but it has measures that are doing funky things with matching dates. (I didn't create this measure I am just updating the report). I am new to powerbi and really don't know what I am doing - please send help lol. I need it to be based off of invoice date in my order his table. Can someone help guide me? 

Rolling 13 POS Units =

    CALCULATE (

        [sum of units],

        FILTER ( 'POS Aggregate', 'POS Aggregate'[week diff POS] <= 12 ))

I created this and its not getting me the results I am wanting. 

Rolling 13  qty shipped =

CALCULATE (

    [sum of qty shipped],  

   DATESBETWEEN('Order History'[Invoice Date], TODAY() - 91, TODAY() - 1)

)

[rubayatyasmin]

Hi, @Igotzepowerbi 

it would be better to create a date table instead of using today(). today will eventually change everyday. 

modified dax

Rolling 13 Weeks Qty Shipped =
CALCULATE(
SUM('Order History'[Qty Shipped]),
FILTER(
ALL('Date'[Date]),
'Date'[Date] >= MAX('Date'[Date]) - 91 &&
'Date'[Date] <= MAX('Date'[Date])
)
)

In this measure, Date would be a separate Date table that has all of the dates and 'Order History' is the table with your shipped quantities.

This assumes that the 'Date' table and the 'Order History' table are related by the date field.