Forum Discussion

Supermat's avatar
Supermat
Helper I
4 years ago
Solved

Date null

I have a coloum date (Integer), i change in text and then in date time but 0 value cause an error. 
How can i fix that?

 

Date
20210101
20210102
0
20210103
20210104
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi Supermat ,

     

    I would suggest after you modify this column to TEXT datatype, add a transformation of replacing 0 with NULL and then tranforming it to Date type. You can easily do this in Power Query editor in Power BI.

     

    This is you date column which is text type:

    Then add a transformation step to replace 0 with Null (as 0 can't be taken as a date)

    Now modify the column data-type to Date type:

    You will get the desired result.

     

    Thanks,

    Pragati

     

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    Hi Supermat ,

     

    I would suggest after you modify this column to TEXT datatype, add a transformation of replacing 0 with NULL and then tranforming it to Date type. You can easily do this in Power Query editor in Power BI.

     

    This is you date column which is text type:

    Then add a transformation step to replace 0 with Null (as 0 can't be taken as a date)

    Now modify the column data-type to Date type:

    You will get the desired result.

     

    Thanks,

    Pragati