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[D...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi BrianSK,

     

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

     

    The result is like below;

     

     

    Regards,

    Jimmy Tao

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi BrianSK,

 

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

 

The result is like below;

 

 

Regards,

Jimmy Tao