Forum Discussion
Getting two latest value two different column in different table
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.
Hi Jihwan_Kim, thank you for the prompt reply,
i have another question which is why when i include the application date into the chart it become like this and not showing the latest date it should be? I'm sorry for not telling the requirement earlier but the application date and status code should be shown also.
output from your edited pbi (thank you again)
expected output
and i need to use the status code to do the filtering and not by application status key. Hoping you have a nice day and can guide me further on this, thank you !
Super UserHi,
Thank you for your explanation.
I fixed the measure.
By the way, if you want to slice by Status, I think creating a new table is also the way.
I am not sure how your expected outcome looks like when slicing by STATUS, but please check the attached file.
I also create a new table.
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
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.
Works like wonders, Thank you for the helps!