Product at the last date by a product

[Margreet]

[Margreet]

[Margreet]

[tamerj1]

@Margreet 

Please try

LastProduct =
MAXX ( TOPN ( 1, 'Table', 'Table'[Date] ), 'Table'[Product] )

[tamerj1 · Accepted solution]

Hi @Margreet 

MaxDate_nr = MAX ( 'Table'[date] )

LastProduct = 

VAR MaxDate = [MaxDate_nr]
RETURN

CALCULATE ( MAX ( 'Table'[Product] ), KEEPFILTERS ( 'Table'[Date] = MaxDate ) )

[Ajendra]

@tamerj1 

You are really a genius !!