how to show only first value filtered by time?

[naifAhmedB]

Hi,

I need help for a better dax.

I have value= open with several times

What I want is to show only the first time open for each day 

I used the filter with hour=5 but I get all values while I want is

16 nov 5:41 AM and 17 Nov 5:50 AM

I tried also the min but I can't see the value for 17 Nov.

 

Any ideas?

thanks

[amitchandak]

@naifAhmedB , You need to take this measure with date.  Make sure you have a date

Date =[Dattime].date

Use Date with min([Date/time]) with visual

[naifAhmedB]

All right i can do that..

Is there a way I can dax filter for previous day only? 

[naifAhmedB]

table for refre: