How to show the first value in certain hour?

[naifAhmedB]

Hi every one,

I really need help on making a dax or filter.

General Details: I have data for every store door opening and closing time

request: to show the first store-door opening time between 5- 6 AM.

Example: The first open in 16 Nov is at 5:41 AM. 

Filter use: I have created a hour column and filtered the 5 AM.

Problems with that: I still see other opening and closing time

Dax required : something like = show value(open/closed), if first( open) in 5 -6 AM. or show the first value (open/close) in certain hour=5 Other notes: The dax has to allow auto-update for date since it will show the report for every day.

[amitchandak]

@naifAhmedB , Not very clear. But you might have to create a time table and have hours there and then create two measures open and close. https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[naifAhmedB]

I have create a table to show only opendoor with filter 5 AM.

Now I want to show only 5:41 AM on nov 16 and  5:50 AM on Nov 17

since they are the first door open time. 

 

[naifAhmedB]

HI again,

I was able to reach this :

any other daxs i can use?