Forum Discussion

Pierre_B's avatar
Pierre_B
New Member
3 years ago
Solved

Create a max date measure for each id

Hi everyone,   I would like to create a measure using dax in order to get the max date for each id and filtered date, and keeping the every date in my table.   date id max date 01/01/2022...
Need Help
  • Barthel's avatar
    Barthel
    3 years ago

    Pierre_B,

    Try using a variable. For me that seems to do the trick.  

     

     

    max date = 
VAR _dates =
    ALLSELECTED ( 'Table'[date] )
VAR _result =
    CALCULATE (
        MAX ( 'table'[date] ),
        REMOVEFILTERS ( 'Table' ),
        VALUES ( 'Table'[id] ),
        _dates
    )
RETURN
    _result

     

     

     

Barthel's avatar
Barthel
Icon for Solution Sage rankSolution Sage
3 years ago

Hey Pierre_B,

Give this a try:

max date = 
CALCULATE ( 
    MAX ( 'table'[date] ),
    ALLEXCEPT ( 'table', 'table'[id] )
)

It calculates the maximum date for each row removing all fitler context of the table, except that of the 'id', so that the maximum date is calculated per 'id'.