cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ebrabender Frequent Visitor
Frequent Visitor

24HR Date Selection

Hi I am extremely new and green to PowerBI.   What I am doing now is building a downtime chart from a manufacturing environment.   What I would like to do though is gather data from 6am until 6am the next day.  IE the data needs to be from 4/12/19 at 6am until 4/13/19 6am and then ignore all data after the 6am time frame on the 13th.  Can someone explain on/where I would do this?

 

Thank You

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: 24HR Date Selection

@ebrabender ,

 

You may simply try FILTER, TODAYDATE and TIME.

https://www.sqlbi.com/blog/alberto/2019/03/25/using-dax-with-datetime-values/

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User
Super User

Re: 24HR Date Selection

@ebrabender can you share sample data and how you want to visualize it?





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




Community Support Team
Community Support Team

Re: 24HR Date Selection

@ebrabender ,

 

You may simply try FILTER, TODAYDATE and TIME.

https://www.sqlbi.com/blog/alberto/2019/03/25/using-dax-with-datetime-values/

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.