Forum Discussion
Lazurens
3 years agoFrequent Visitor
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
| Category | Value | Date |
| AB | 45 | 24/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 tryMasterdata 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
Community Champion
Hi Lazurens
Please tryMasterdata 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] ) )