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

     

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