update blank Values in formula column

[Hesham]

Hello,

i am new in Power Bi and need help.....

i write a formula to be updated based on two other colunms (Time Columns with format HH:MM) , it worked perfect but the problem it retrun the 00:00 value in the final_time with blank and that make a problem in the charts. any help .....

i need it to return same value "00:00"

Final_Time = IF(Source[Day_time]=BLANK(),IF(Source[Day_time2]=BLANK(),Source[Day_time],Source[Day_time2]),IF(Source[Day_time]=BLANK(),Source[Day_time2],Source[Day_time]))

Best rgards

Hesham

[Greg_Deckler · Accepted solution]

You might try using CONCATENATE with a "" when returning values to make your end result column Text, so something like:

IF(Source[Day_time]=BLANK(),
	IF(Source[Day_time2]=BLANK(),
		CONCATENATE(Source[Day_time],""),
		CONCATENATE(Source[Day_time2]),""),
	IF(Source[Day_time]=BLANK(),
		CONCATENATE(Source[Day_time2],""),
		CONCATENATE(Source[Day_time]),"")
)

[Hesham]

Many Thanks Smoupre for your efforts, i got the idea and did work around by update it from another dummy table.