recent date and time.
2 TopicsFind Next Most Recent Date Dynamically
Hi, I'm struggling to find a solution in the forum for what I'm trying to accomplish, with that being said thank you and I appreciate any/all help to the resolution to (or guidance to a similar situation that may help resolve) my issue. I have a table similar to below PJB_ID Created_By Created_Date 1111 [email protected] 1/13/22 1112 [email protected] 2/21/22 1113 [email protected] 3/17/22 1114 [email protected] 2/5/22 1115 [email protected] 1/29/22 1116 [email protected] 4/5/22 1117 [email protected] 2/22/22 1118 [email protected] 3/24/22 The first thing I want to do is have a visual (table) that displays the most current PJB_ID the individual created something like this: PJB_ID Created_By Created_Date (most recent) 1117 [email protected] 2/22/22 1116 [email protected] 4/5/22 1118 [email protected] 3/24/22 Then if I have a date slicer and someone selects a date that is prior to the (most recent) created date, it will display the next most recent. So the table then would look like this if 2/1/22 was selected from the slicer: PJB_ID Created_By Created_Date 1115 [email protected] 1/29/22 1111 [email protected] 1/13/22 null [email protected] null I've tried to use the max, last date, and a few other functions but can't seem to get it to work the way I want. I apologize if this type of issue has been resolved already and if it has and someone can shoot me a link to the post, I'd greatly appreciate it. Thanks for giving this a look and helping. Regards, CodySolved1.2KViews0likes6CommentsI 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