Need help to get DAX to pull latest message based on the date included in the message

[KSPG]

attached data sample here

ColumnA

10/5/2022 5:35:52 PM, abcdefghijklmnopqrstuvwxyz

10/2/2022 9:41:39 PM, abcdefghijklmnopqrstuvwxyz

9/23/2022 6:35:33 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 10:39:04 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 10:38:49 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 6:34:23 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 6:00:00 PM, abcdefghijklmnopqrstuvwxyz

9/3/2022 4:32:16 PM, abcdefghijklmnopqrstuvwxyz

8/22/2022 6:16:21 PM, abcdefghijklmnopqrstuvwxyz

10/5/2022 5:35:52 PM, abcdefghijklmnopqrstuvwxyz

10/2/2022 9:41:39 PM, abcdefghijklmnopqrstuvwxyz

9/23/2022 6:35:33 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 10:39:04 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 10:38:49 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 6:34:23 PM, abcdefghijklmnopqrstuvwxyz

9/22/2022 6:00:00 PM, abcdefghijklmnopqrstuvwxyz

9/3/2022 4:32:16 PM, abcdefghijklmnopqrstuvwxyz

8/22/2022 6:16:21 PM, abcdefghijklmnopqrstuvwxyz

4/18/2022 7:00:00 PM, abcdefghijklmnopqrstuvwxyz

[Shaurya · Accepted solution]

Hi @KSPG,

Even though this can be a lot simpler task in Power Query, since you have asked in DAX, here you go. Create two new columns, one for Date and another for Text based on the position of the comma.

Date = LEFT('Table'[Message],SEARCH(",",'Table'[Message])-1)

Text = MID('Table'[Message],SEARCH(",",'Table'[Message])+2,LEN('Table'[Message]))

Now create this measure and add it in a card visual:

Latest Message = CALCULATE(MAX('Table'[Text]),FILTER('Table','Table'[Date]=MAX('Table'[Date])))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison