MAX Date per Material where Measure > 0

Anonymous — Thu, 09 Jun 2022 09:51:33 GMT

Hi, what I am trying to do is to get the maximum date by Material. I'm using datasets, tables with attributes, and tables with measures.

DAX:

EVALUATE
SUMMARIZECOLUMNS (
    'Material'[MAT WRIN0],
    'Delivery Date'[DLVD Date],
    'Purchase Order'[PO Number],

    FILTER (
        VALUES ( 'Distributor'[DIST Country] ),
        ( 'Distributor'[DIST Country] = "Romania" )
    ),
    FILTER (
        VALUES ( 'Purchase Order'[PO Status Description] ),
        ( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" )
    ),

"Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity]
)
ORDER BY 'Delivery Date'[DLVD Date]

Here is the data extract, and the final result should be like WRIN0 and Max DLVD Date (just one line per WRIN0).

Re: MAX Date per Material where Measure > 0

tamerj1 — Thu, 09 Jun 2022 11:38:21 GMT

Hi Anonymous

please use

EVALUATE FILTER ( SUMMARIZECOLUMNS ( 'Material'[MAT WRIN0], 'Delivery Date'[DLVD Date], 'Purchase Order'[PO Number], FILTER ( VALUES ( 'Distributor'[DIST Country] ), ( 'Distributor'[DIST Country] = "Romania" ) ), FILTER ( VALUES ( 'Purchase Order'[PO Status Description] ), ( 'Purchase Order'[PO Status Description] = "Purchase order APPROVED" ) ), "Purchase Order To Be Received Quantity", [Purchase Order To Be Received Quantity] ), 'Delivery Date'[DLVD Date] = CALCULATE ( MAX ( 'Delivery Date'[DLVD Date] ), ALLEXCEPT ( 'Material', 'Material'[MAT WRIN0] ) ) ) ORDER BY 'Delivery Date'[DLVD Date]

topic MAX Date per Material where Measure > 0 in DAX Commands and Tips

MAX Date per Material where Measure > 0

Re: MAX Date per Material where Measure > 0