Replace date column value with null

[BrianSK]

I have a powerbi table datasource that is bringing in 1900/01/01 value into the table.

I need to replace this value with null. I tried below function but it's not working

NewDate = if(Table[Date] = DATE(1900,01,01),BLANK(),Table[Date])

If I try to replace it with text value null, I see datatype error since the false condition returns date type.

[v-yuta-msft · Accepted solution]

Hi BrianSK,

You can click Query Editor->Transform->Replace Values

 

The result is like below;

 

Regards,

Jimmy Tao