topic Re: How to show the first value in certain hour? in DAX Commands and Tips

How to show the first value in certain hour?

naifAhmedB — Tue, 17 Nov 2020 11:38:05 GMT

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.

Re: How to show the first value in certain hour?

amitchandak — Tue, 17 Nov 2020 11:55:12 GMT

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/

Re: How to show the first value in certain hour?

naifAhmedB — Tue, 17 Nov 2020 14:06:53 GMT

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.

Re: How to show the first value in certain hour?

naifAhmedB — Tue, 17 Nov 2020 15:26:15 GMT

HI again,

I was able to reach this :

any other daxs i can use?