Forum Discussion
Solved
How to sum multiple latest values based on timestamp column which have the same opp nº?
Hello!
The measure below does get the latest of each and that works when I place it into a table visual, but not on a card. It only plots the last value found, instead of summing the latest of each opportunity.
TotalR$Oportunidade =
VAR _max =
MAXX (
FILTER (
ALLSELECTED ( BDOportunidades ),
BDOportunidades[Nº da Op.] = MAX ( BDOportunidades[Nº da Op.] )
),
BDOportunidades[Timestamp]
)
RETURN
CALCULATE (
SUM ( BDOportunidades[Total R$]), BDOportunidades[Timestamp] = _max
)
Appreciate your help!
