Forum Discussion
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 dat...
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,
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,