Similar equation producing error message in one column

[estake]

I am calculating the amount of time to close a case during business hours which is a dynamic number based on the group.  I am using a similar function to do so while only changing the open date and closed date for the two equations but receive an error message with the second equation.  

*FirstDayEndTime =

DATE ( YEAR ('Case'[CreatedDate]), MONTH ('Case'[CreatedDate]), DAY ('Case'[CreatedDate]))

& " " & TIME(HOUR(Case[BusHrEnd]), MINUTE(Case[BusHrEnd]), SECOND(Case[BusHrEnd]))

This equation works perfectly in combining the date and hour closed together. 

*LastDayEndTime =

DATE ( YEAR ('Case'[ClosedDate]), MONTH ('Case'[ClosedDate]), DAY ('Case'[ClosedDate]))

& " " & TIME(HOUR(Case[BusHrEnd]), MINUTE(Case[BusHrEnd]), SECOND(Case[BusHrEnd]))

This equation produces the follow error message:

Cannot convert value '' of type Text to type Date.

Does anyone have any suggestions?  All columns are formated the same. 

[tarunsingla · Accepted solution]

Your second formula breaks probably because of null or blank values in the ClosedDate field. You may want to add a check using IF condition in your formula if that is the case.

e.g. 

LastDayEndTime = IF(ISBLANK('Table'[Date]), BLANK(), 'Table'[Date] + 'Table'[Time])

Regards,

Tarun
Did I answer your question? Mark my post as a solution!

[estake]

That did the trick, thank you Tarun