Date null

[Supermat]

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

[Supermat]

@Pragati11 Thx for your support

[Pragati11 · Accepted solution]

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