View Records with the Maximum Date

Hi spandy34 ,

try this:

CALCULATE (
    MAX ( 'tasks main'[due date] ),
    ALLEXCEPT (
        'tasks main',
        'tasks main'[mission],
        'tasks main'[project],
        'tasks main'[life cycle phase]
    )
)

hi spandy34 

Replace ORD_ID and MLSTN with the fields you want to get the maximum date for. Similarly you can add more fields.

In CALCULATE , I am removing all filters and adding only those fielters for which I want to get the maximum date.

This is a Calculated Column

------------------------------------

Max Date by =

VAR _Ord_ID = Orders[ORD_ID]

VAR _MLSTN = Orders[MLSTN_CD]

RETURN CALCULATE( MAX(Orders[RECEIVED DATE]), REMOVEFILTERS(), Orders[ORD_ID] = _Ord_ID && Orders[MLSTN_CD] = _MLSTN)