Forum Discussion
novicenovice
Helper I
Helper IFind date with several filters
Dear All, Hope you can help me : we are the 29/11 and we need to find if there is a new delivery date for the previous extraction items EXTRACTION DATE ORDER ITEM ORDER DT_DELIVERY...
novicenovice,
You can get expected result by creating a simple measure.
Measure = MAX(T_DATA_OPEN[DT_DELIVERY])
If you need to create a calculted column, use DAX below.
Column = VAR ORDERid = T_DATA_OPEN[ORDER] VAR ITEMID=T_DATA_OPEN[ITEM ORDER] RETURN CALCULATE(MAX(T_DATA_OPEN[DT_DELIVERY]),FILTER(T_DATA_OPEN,T_DATA_OPEN[ORDER]=ORDERid && T_DATA_OPEN[ITEM ORDER]= ITEMID))
Regards,
Lydia
parry2k
Super User
Super UserI guess you are looking most recent delivery date for an order, correct?
novicenoviceHelper I
Helper IYes, on orders and the item order