Hi @everyone

[Ck0303]

I want to show the last value of column by inventory id. but it is showing first value. how do i fix it ?

My current formula:

LOOKUP([Inventory ID], "Ordered", "Inventory ID", "Price")

[1minManager]

MAX(Select(Ordered[_RowNumber],[Inventory ID]=
  Select(Ordered[Inventory ID],TRUE))
))

So you've not really given us any info about the columns you have and what they do.  But the above says  

Select(Ordered[Inventory ID],TRUE))

 Go and get a list of rows depending on something.  "TRUE" means pull in everything so you'll want to change that.  I'm also assuming that [Inventory ID] is the key column.

MAX(Select(Ordered[_RowNumber],[Inventory ID]=

So from the list created above, get me the highest row number and then return just that row.  You might want something else other than _RowNumber

Simon

1minManager.com

[Ck0303]

inventory id is name of the item and i wanted to find item's last value by inventory id. and last value is item's price or something 

[Steve]

Tty:

ANY(
  SELECT(
    Ordered[Price],
    (
      MAX(
        SELECT(
          Ordered[_ROWNUMBER],
          ([_THISROW].[Inventory ID] = [Inventory ID])
        )
      )
      = [_ROWNUMBER]
    )
  )
)

How do I get a column value from the last row of this thing only?