Forum Discussion
ebrabender
7 years agoNew Member
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
You may simply try FILTER, TODAY, DATE and TIME.
https://www.sqlbi.com/blog/alberto/2019/03/25/using-dax-with-datetime-values/
2 Replies
- parry2kSuper User
ebrabender can you share sample data and how you want to visualize it?
- v-chuncz-msftCommunity Support
You may simply try FILTER, TODAY, DATE and TIME.
https://www.sqlbi.com/blog/alberto/2019/03/25/using-dax-with-datetime-values/