Modify Calculated Table for Earliest Start Week

[DataUsurper]

I have the following function to create a table where each record lists the week-start date along with the correlating product code and orderid where a "1" is placed when an order falls within that record's week-start date (which is between the order's Ship and Return dates).

wtbl_WROR = 
VAR a =
    CALENDAR(MINX('1','1'[SHIP_DATE]),MAXX('1','1'[cRETURNDATE]))
VAR b =
    SELECTCOLUMNS (
        tbl_OrderData1,
        "sORDERID.DAX",tbl_OrderData1[s_OrderID_DAX],
        "eCODE",tbl_OrderData1[eCODE]
    )
RETURN
    FILTER ( CROSSJOIN ( a, b ), WEEKDAY ( [Date], 2 ) = 1 )

Which produces this table:

However, I have ship start dates that are 9/1 which aren't getting produced on this list where I would expect the lowest date record reflecting 8/28/17. What am I missing in the MINX field to accomplish this?

Thank you
DU

[v-yuta-msft]

@DataUsurper ,

---

However, I have ship start dates that are 9/1 which aren't getting produced on this list where I would expect the lowest date record reflecting 8/28/17. What am I missing in the MINX field to accomplish this?

---

I'm confused on your requirement, could you please clarify more details about your requirement and give the expected output?

Regards,

Jimmy Tao