last update value

[#1]

Hello,

i have a costprice table wit 3 FIELDS

ITEMID | COSTPRICE | MODIFIEDDATE

i need anytime the last costprice per ITEMID

can u explain me how i can get these values in an expression?

[MK_QSL · Accepted solution]

Create a Straight Table

Dimension

ITEMID

Expression

FirstSortedValue(COSTPRICE,-MODIFIEDDATE)