Forum Discussion

IkmalFikri900's avatar
IkmalFikri900
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    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.

     

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
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.