Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |