Cannont convert value " of Type text to type Date

[Birdjo]

Hello,

I am getting the followin error:

I don't what's the issue. The source columns for this calculated column has no errors and is in proper type.

[v-yulgu-msft]

Hi @Birdjo,

There existing a date type column and time column in table 'Logs', right? After loading data into desktop, the time column will be converted to date/time automatically. You can check this in Query Editor mode. Please first change its data type to "Time".

Then, you could use the CONCATENATE function to combine two columns. Remember to change the data type of [Entry datetime] from Text to Date/Time.

Best regards,

Yuliana Gu

[Birdjo · Accepted solution]

Thank you very much, guys!

The types were OK.

I tried different formats yesterday, none worked. I resolved the issue by finding a null value in the dataset.
I asked the responsible employee to fix it and it worked.

[vega]

I think you want to use the FORMAT DAX function to convert the date into a text. You can see more about it here.