Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting two latest value two different column in different table

Hi all, I have some difficulties and i need some help.    My task is to get the latest application date and also the latest status from that application date without using the power query, only the...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for your message.

    I created a measure for application date as well.

    Please check the attached file, and please check if it suits your requirement.

    Thank you.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jihwan, thank you again for your prompt reply, i really do appreciate your concern on this issue.

But apparently i'm still having the same result which is this, 

expected result(without selecting anything from the slicer), as you can see, it's showing the latest date and the latest status which is for example for student A2, there same status in the different latest date(rejected). the result that it should be is only on the latest one which is on 2 January. 

Hoping that you can provide your insights more on this, thank you!

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Thank you for your message.

I created a measure for application date as well.

Please check the attached file, and please check if it suits your requirement.

Thank you.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Works like wonders, Thank you for the helps!