Forum Discussion
Get latest status based on same identifier
HI IkmalFikri900
The file shared by Ashish_Excel provides accurate results as per the request.
To display 200 in your card, I would recommend using Latest measure where it will correctly display the expected value.
See below image for reference-
Reuploadiing the pbix for reference.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
you can try to create a new table
Hi, thanks for the suggestions, but it doesn't fit my requirement, can you assist?
then pls provide more details about your request. what is the expected output?
Sample Data:
ID LinkedID Date StatusUpdate Values IssueStatus 1 1 1-Jan-25 Update 1 100 Ongoing 2 1 2-Feb-25 Update 2 150 Completed 3 3 1-Jan-25 Update 3 200 Ongoing 4 3 2-Feb-25 Update 4 200 Ongoing So, the expectation is, when User filter ALL Date Column, visuals should display this
Info Ongoing Cases 1 Completed Cases 1 Values 350 Since for the latest item (ie February), the latest IssueStatus is Completed and Latest Value is 150 for LinkedID 1. but LinkedID 2 stays the same
When the user Filter January 2025 only, visuals should display:
Info Ongoing Cases 2 Completed Cases 0 Values 300 Since in January, both LinkedID 1 and 2 status is Ongoing and the value is 100+200