Inserting lastest purchase date in tabel

[Lautorp]

I'm trying to get the most recent date of my purchase in on my table showing my products on stock. 

I would like to show my latest purchase date on each item listed in my stock report, so I have a complete overview on how old my stock is.

I have tried with LASTDATE or MAX, but can't seem to make it work. 

All my purchase data is located in my table LAGPOST (2).

Any good suggestions?

[Zubair_Muhammad]

Hi @Lautorp

Try this pattern

=
CALCULATE (
    MAX ( TableName[Date] ),
    ALLEXCEPT ( TableName, TableName[Products] )
)

[Lautorp]

It looks like it just return the higest number in the date coloum. 

[iamprajot · Accepted solution]

This solution is OK and working on my data.

Just try to create the table from scratch and you can use matrix table too for clear understanding.

Also, there is an alternate formula which is similar,

Measure =LASTNONBLANK(TableName[Date],MAX(TableName[Date]))

and you can also put the Date Column into the Table and Choose Latest