the last process in a year in a table

[Hikmet_JCI]

Hello

could someone help me please

i try to show the last process in a year in a table

which is filtered on a customer

THANKS

[Hikmet_JCI]

[Anonymous · Accepted solution]

hi @Hikmet_JCI ,

Try this

_Measure = IF ( Customer[Date] = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez] ) ),Customer[Date] )

Thanks!

[Anonymous]

hi @Hikmet_JCI 

Did you try this

_Measure = IF ( MAX(Customer[Date]) = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez],Customer[KD] ) ),MAX(Customer[Date]) )

[ryan_mayu]

@Hikmet_JCI 

you can try to create a column

Column = 
VAR _max=CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Art]))
RETURN if(_max='Table'[Date],'Table'[Date],blank())

[Hikmet_JCI]

Hi.
but when I use a filter it doesn't show me correctly

I would have to consider one more column

[ryan_mayu]

@Hikmet_JCI 

then you just need to create a measure

Measure = max('Table'[Date])

please see the attachment below