24HR Date Selection

[ebrabender]

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

[v-chuncz-msft · Accepted solution]

@ebrabender ,

You may simply try FILTER, TODAY, DATE and TIME.

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

[parry2k]

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