Forum Discussion

BrianSK's avatar
BrianSK
Regular Visitor
8 years ago
Solved

Replace date column value with null

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.

  • Hi BrianSK,

     

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

     

    The result is like below;

     

     

    Regards,

    Jimmy Tao

     

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi BrianSK,

     

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

     

    The result is like below;

     

     

    Regards,

    Jimmy Tao