Forum Discussion

Faadiz's avatar
Faadiz
Frequent Visitor
8 years ago
Solved

Error on cells with no date

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

 

Need Help
Show and Tell
Tutorial Requests
  • ibarrau's avatar
    ibarrau
    8 years ago

    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,

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    8 years ago

    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,