"Add one day to date if time between" works sometimes, not always

[TheBaz_57]

Hi all,

I have in powerbi a table that is like this:

I have a column with Time, Date and Business date. For some reason my business day is from D-1 21:00:00 to D 21:00:00.

So I want to get the business date by adding 1day to the date when time is between 21:00:00 and 23:59:59. 

The column "business date" is a caculated column with this formula: 

Business Date = IF(ODRs[Time]>TIME(21,00,00) && ODRs[Time]<TIME(23,59,59), DATEADD(ODRs[Date],1,DAY))

However, as you can below from the image sometimes it works sometimes not.

i.e why 21:47:52 is considered on not 23:18:24 ?

Thank you

[TheBaz_57 · Accepted solution]

Seems it is returning blank when day calculated by DATEADD is a weekend.

Solved it by having a calculated column with WEEKDAY, return the day of the week and my column business day is calculated with IF WEEKDAY = 6 DATEADD+2 else +1