Forum Discussion

novicenovice's avatar
novicenovice
Icon for Helper I rankHelper I
8 years ago
Solved

Find 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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

novicenovice's avatar
novicenovice
Icon for Helper I rankHelper I
8 years ago

Hello Lydia,

 

Thanks it works :)

 

Regards.

 

novice