cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Birdjo Member
Member

Cannont convert value " of Type text to type Date

Hello,


I am getting the followin error:
error.jpg

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Birdjo Member
Member

Re: Cannont convert value " of Type text to type Date

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.

3 REPLIES 3
vega Member
Member

Re: Cannont convert value " of Type text to type Date

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

Community Support Team
Community Support Team

Re: Cannont convert value " of Type text to type Date

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".

1.PNG2.PNG3.PNG

 

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.

4.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Birdjo Member
Member

Re: Cannont convert value " of Type text to type Date

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.