Null Vales and Time Column

[bdehning]

Is there a way to replace null values with other text in a Time Column?    

When I use the column for a Table, it shows all nulls as Blank and I would like other text.   

[v-zhangti · Accepted solution]

Hi, @bdehning 

The data type of a column has to be the same. The value in the middle of the time column cannot be converted to a text value.

Column = IF([Time]=BLANK(),TIME(0,0,0),[Time])

Does this solve your problem?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Even if you can do that, you should not because in a single column the same data type should be maintained.

[amitchandak]

@bdehning , In power query you can do replace null ( all small null) with a value. But make sure you choose timeline 00:00:00  or  0 else data type conversion might fail

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

In Dax new column

coalesce([Time], time(0,0,0) )