Forum Discussion

Lazurens's avatar
Lazurens
Frequent Visitor
3 years ago
Solved

Get Rows with last change with the date

Hello everyone,    I have a table containing for value   Category AB have value 34 at date 23/03/2023 and the days after it has another value 45 I need to get the last value with the last date ...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Lazurens 
    Please try

    Masterdata LastChange =
SUMMARIZE (
    'Masterdata',
    'Masterdata'[FAMILLE_PRODUCTION],
    "Cadence Opérationnelle",
        CALCULATE (
            MAX ( 'Masterdata'[CADENCE_OPERATIONNELLE] ),
            'Masterdata'[DERNIER_CHANGE] = MAX ( 'Masterdata'[DERNIER_CHANGE] )
        ),
    "Dernier Change", MAX ( 'Masterdata'[DERNIER_CHANGE] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Lazurens 
Please try

Masterdata LastChange =
SUMMARIZE (
    'Masterdata',
    'Masterdata'[FAMILLE_PRODUCTION],
    "Cadence Opérationnelle",
        CALCULATE (
            MAX ( 'Masterdata'[CADENCE_OPERATIONNELLE] ),
            'Masterdata'[DERNIER_CHANGE] = MAX ( 'Masterdata'[DERNIER_CHANGE] )
        ),
    "Dernier Change", MAX ( 'Masterdata'[DERNIER_CHANGE] )
)