24hr Date Selection From 6am to 6am

[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-danhe-msft · Accepted solution]

Hi @ebrabender ,

Based on my test, you could refer to below steps:

Sample data:

Create a new table:

Date = VALUES(Table1[Date])

And a new measure:

Measure = var a=SELECTEDVALUE('Date'[Date])
return IF(CALCULATE(MAX('Table1'[Date]))>=a&&CALCULATE(MAX('Table1'[Date])<=a+1),CALCULATE(MAX('Table1'[Value])),BLANK())

Use the 'Date'[Date] as slicer:

You could also download the pbix file to have a view.

Regards,
Daniel He