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

CategoryValueDate
AB4524/03/2023

My try partially works :

 

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

 

When I add the date column I get all the rows without the filter

Can any one help me add the [DERNIER_CHANGE]

Thanks in advance 🙂

  • 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] )
    )

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    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] )
    )