Filter Max time per day

[Anonymous]

How can I filter the day and night per day to only show the latest data. I have tried filter by last min/hr but it does not work for my data.

The data that comes in from the source only includes personel that is present. The Date coming in because of it comes from the powerapp, each row is populated at different time, so i have rounded it to the nearest 5 minutes since one submittion takes less than 5 minutes. 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Add a measure like:

flag =
VAR _maxtime =
    CALCULATE (
        LASTNONBLANK ( 'Table'[DateTime], 1 ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] = MAX ( 'Table'[Date] )
                && 'Table'[Name] = MAX ( 'Table'[Name] )
        )
    )
RETURN
    IF ( MAX ( 'Table'[DateTime] ) = _maxtime, 1, 0 )

Then apply this measure to the table filter pane:

Best Regards,
Community Support Team _ Eason