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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JoseHop
Helper I
Helper I

ID-PRODUCT combination -> what is the result on the newest date?

ID-PRODUCT RESULT NEWEST DATE 

I want to know per ID what the result is on the most recent date per product. How do I do that in Power BI? See enclosed PBIX for dates and examples of results. Thanks in advance,

https://grouphub-my.sharepoint.com/:u:/g/personal/jose_hoppenbrouwer_gro-up_nl/EVv1pVWbmqlAkXtI1K6_b... 

2 REPLIES 2
amitchandak
Super User
Super User

@amitchandak thank you for your reply. The blog you send is not exactly the answer. 

I would like to know the newest of 2 items: ID + Product 
In this example: 

DATA: 

201680MATCHING9-3-2022 08:47MATCH
201680COMPENSATION7-7-2022 09:07ACCEPTED
201680COMPENSATION1-8-2022 12:15REJECTED

 

RESULT: (I'm looking for)

201680+MATCHING = MATCH

201680+COMPENSATION = REJECTED

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!