Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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,
@JoseHop , refer if the blog on the same topic can help
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
@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:
201680 | MATCHING | 9-3-2022 08:47 | MATCH |
201680 | COMPENSATION | 7-7-2022 09:07 | ACCEPTED |
201680 | COMPENSATION | 1-8-2022 12:15 | REJECTED |
RESULT: (I'm looking for)
201680+MATCHING = MATCH
201680+COMPENSATION = REJECTED
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |