How to create a measure that returns the most recent value of a stock

[Celso]

Hello,

I have a table that looks similar to this. I want to create a measure that returns the most recent value and I want it to be responsive with my date selection. Thank you.

[Greg_Deckler]

You would want to create a measure using MAX([Transaction Date]). Not entirely sure what you are going for here but you could you could use this in a CALCULATE for [Value ($)] for example.

[Celso]

My goal is to create measure maybe for a card that displays the total value. The value would be the total of last value of the stock (in the example on 104 for Gold Mining A, 57 for Invest Co and 122 for Airline A). 

I also want to use the Transaction date column as a slicer that when I select July I'm only seeing the total of Gold Mining A and Invest Co. 

[erik_tarnvik]

Create a measure that extracts the latest Date for your context:

MaxDate = CALCULATE(MAX(Stock[Date]),  ALLEXCEPT(Stock,Stock[Category]) )

and a measure that summarizes Value based on MaxDate:

SumStockValue = CALCULATE(SUM(Stock[Value]), FILTER(ALLSELECTED(Stock),Stock[Date] = [MaxDate]))

This assumes you have only one row per date and category. The measures will respect the context created by any selection (by slicer for example) based on [Date].

[Greg_Deckler · Accepted solution]

You should be able to get there from here:

CategoriesLatest = SUMMARIZE(Categories,Categories[Product Category],"Transacation Date",MAX(Categories[Transaction Date]),"Value",CALCULATE(SUM(Categories[Value ($)]),FILTER(Categories,Categories[Transaction Date]=MAX(Categories[Transaction Date]))))

[Celso]

Thank you.