Error on cells with no date

[Faadiz]

Hello,

i am a marketing guy with personal interest in learning Power BI. for below table, there are some dates for which there should not be any data.

since i have marked entire column as date, Power BI is giving error. 

please help

[ibarrau · Accepted solution]

Hi. Assuming you are reading the data from a file. You can replace value "-" to null before converting the column to date.

You can also replace errors with null after converting the column to date, but this is way not recommended because you may not recognize a true error in data.

Regards,