Forum Discussion
IkmalFikri900
1 year agoFrequent Visitor
Get latest status based on same identifier
Hi everyone, I want to develop this, basically, it will display status based on the latest status accoridng to the Linked column..if the user did not select any specific quarter/year...but if t...
- 1 year ago
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.
Ashish_Excel
1 year agoSolution Supplier
IkmalFikri900
1 year agoFrequent Visitor
Thanks. it helps a lot,
Just the Values/T amount where if no filter is selected for ongoing, it shows 500 where it should shows 200 only
- Ashish_Excel1 year agoSolution Supplier
You are welcome. Cannot understand your concern.