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")
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
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
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?
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |