find latest datetime for each faultid per day.

What about the records with no close date/time? What value should be there? You can use SUMMARIZE() or SUMMARIZECOLUMNS() to return a table of the last time per (FaultID, Date) and then just return MAX( Time ). Then join that back to the original table if you want to grab more columns.