recent data
2 TopicsMost Recent Discharge Date Row Record
Please how can I get the most recent row values if I have a sample data like this. I used the calculate and filter allexcept function but I got only the dates and not the corresponding Ids. Table: patient_name patient_Id discharge_date record_Id Mark 1 3/15/2019 1001 John 2 6/3/2020 1002 Tom 3 8/7/2020 1003 Tom 3 9/1/2020 1004 Tom 3 9/3/2020 1005 Sarah 4 2/1/2018 1006 Kim 5 7/6/2017 1007 Mark 1 4/7/2020 1008 Tom 3 11/1/2020 1009 Steve 6 3/2/2019 1010 Expected Results: patient_name patient_Id discharge_date record_Id John 2 6/3/2020 1002 Sarah 4 2/1/2018 1006 Kim 5 7/6/2017 1007 Mark 1 4/7/2020 1008 Tom 3 11/1/2020 1009 Steve 6 3/2/2019 1010 Thank you so much.Solved1KViews0likes3CommentsI want to get the recent data out of the record with Date (with recent Time as well)
Hello, I am trying to fetch the recent data not only to the recent date but to the recent time as well and then provide the count of that data afterwards. I am trying multiple queries provided in the forum but none has worked so far. The data is something like this and the yellow rows are the recent record. Please provide me with a solution weather I should do it as a calculated columns or a measure. And if a new column has to be made, how should I do that.Solved1.2KViews0likes4Comments