Fetching data within date and time range

[shubh307]

Hi All,

I need to fetch data let's say from date 26th March 2019 9:00am to 27th March 2019 8:59 am (1st bar) similarly for other dates. 

Lets say if total placed orders for 26-27 is 50 and 27-28 is 70 from 9:00 am to 8:59 am, two bars should be avilable with respective data.

I have a master calendar and created datekey and time key to fetch data.

Any help or suggestion would be really helpful 

[Vegar]

Consider introducing a new field to your calendar, let's call it [business date]. It should be a date field with a slew on when the date starts.

To do this you could use the DayName () function utalising the third parameter, day start, and set the business date to start at 9 am and end 8:59 the next day.