Forum Discussion
Can't convert text to date
Hi, I can't convert a text to date column. My dates column has some empty / "NA" values in it. When I try to convert to date type, I get an error that says "We can't automatically conve...
Anonymous
Please refer the below snippet to exclude "NA" from the data columns and convert from Text to Date.
For more details, please refer the below link to download the PBIX file for reference.
http://www.mediafire.com/file/obgpdl22wc58cq6/Zebing-DateTable-NA_exclude.pbix/file
If this post was helpful may I ask you to mark it as solution and give it some kudos?
BR
Venal.
v-diye-msft
Community Support
Community SupportHi Anonymous
It's the NA text affecting the format conversion. would you mind remove them or replace them with "null" and try again?
Tried, but same result. Thanks.