Max value of a datetime per category

[kleysonr]

Hi,

I have the following table:

I need to create an individual measure for each category Table[Name] getting the Table[Value] for the Lastdate of the category.

My last try was the below, but no success:

Last Value of A = 
  var _name = "A"
  var _lastdate = LASTDATE(MyTable[Datetime])
  var _maxvalue = CALCULATE(
    MAX(MyTable[Value]),
    FILTER(
        all(MyTable),
        MyTable[Datetime] = _lastdate && MyTable[Name] = _name
    )
)
return _maxvalue

This table is supposed to be big because it's receiving streaming data and keeping the history.

How to create a measure that give me the last value of A considering the performance for calculation on a streaming table ?

Best Regards.
Kleyson Rios.

[tamerj1 · Accepted solution]

Hi @kleysonr 

if you are slicing by name in your visual then delete the name filter part

Last Value of A =
VAR _name = "A"
VAR _lastRecod =
TOPN ( 1, FILTER ( MyTable, MyTable[Name] = _name ), MyTable[Datetime] )
VAR _maxvalue =
SUMX ( _lastRecod, MyTable[Value] )
RETURN
_maxvalue

[kleysonr]

Thanks.