Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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