Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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/
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.
HI again,
I was able to reach this :
any other daxs i can use?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |