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 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

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.