Forum Discussion
Solved
Show Latest Value & Last N Values
I apologise in advance that I cannot show any data so will try to describe and provide rough examples. I am trying to display the latest given grade (A, B, or C) for a component for an overall it...
Hi AnonymousEngi,
As per my understanding, you want to display Latest Value & Last N Values, based on my understanding I treid to come up with a solution in the below pbix file.Show Latest Value & Last N Values.pbix
Please check the above pbix file. Hope this help to solve the problem. Please let me know if you have any further questions or need clarifications.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
Input Table
| Hierarch | Child | Grade | Date |
| Tree 1 | Branch 1 | B | 1/12/2025 |
| Tree 1 | Branch 1 | B | 1/11/2025 |
| Tree 1 | Branch 1 | A | 1/10/2025 |
| Tree 1 | Branch 2 | B | 1/12/2025 |
| Tree 1 | Branch 2 | A | 1/11/2025 |
| Tree 1 | Branch 2 | B | 1/10/2025 |
| Tree 1 | Branch 3 | C | 1/12/2025 |
| Tree 1 | Branch 3 | B | 1/11/2025 |
| Tree 1 | Branch 3 | B | 1/10/2025 |
| Tree 2 | Branch 1 | A | 1/12/2025 |
| Tree 2 | Branch 1 | C | 1/11/2025 |
| Tree 2 | Branch 1 | B | 1/10/2025 |
Output Table
| Hierarch | Child | Most Recent Grade | Last N Grades |
| Tree 1 | Branch 1 | B | B < B < A |
| Tree 1 | Branch 2 | B | B < A < B |
| Tree 1 | Branch 3 | C | C < B < B |
| Tree 2 | Branch 1 | A | A < C < B |
Ashish_Mathur
Super User
Super UserHi,
PBI file attached.
Hope this helps.