Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
antoniosantos
Frequent Visitor

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!
1 ACCEPTED SOLUTION
1 REPLY 1

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.