Reply
Highlighted
Member
Posts: 66
Registered: ‎12-01-2017
Accepted Solution

Error: Cannot convert value 'Oct' of type Text to type Date.

I am creating calculated column from "datetame" type  column and want to show only names of month, but i'm getting this error: Cannot convert value 'Oct' of type Text to type Date. 

Calculated Column = FORMAT(PRXGetFinishedRequestsView[REQUESTCREATETIME],"mmm")


Accepted Solutions
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Error: Cannot convert value 'Oct' of type Text to type Date.

Hi @giorgilomidze

 

Are you sure your REQUESTCREATETIME column is date time?  The error suggests it might be text already.

 

If it is text and only as values such as "OCT" then you can use the following calculation to convert

 

Calculated Column = FORMAT(DATEVALUE("1/" & PRXGetFinishedRequestsView[REQUESTCREATETIME]),"MMM")

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post


All Replies
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Error: Cannot convert value 'Oct' of type Text to type Date.

Hi @giorgilomidze

 

Are you sure your REQUESTCREATETIME column is date time?  The error suggests it might be text already.

 

If it is text and only as values such as "OCT" then you can use the following calculation to convert

 

Calculated Column = FORMAT(DATEVALUE("1/" & PRXGetFinishedRequestsView[REQUESTCREATETIME]),"MMM")

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Frequent Visitor
Posts: 2
Registered: ‎10-16-2018

Re: Error: Cannot convert value 'Oct' of type Text to type Date.

are you ready for this? we are in the US and we have a customer accessing a report in Germany and the parmeter is coming across as "Okt" instead of "Oct".  Will this solution work?

Frequent Visitor
Posts: 2
Registered: ‎10-16-2018

Re: Error: Cannot convert value 'Oct' of type Text to type Date.

I am not sure if you saw my original reply............

 

So i have a report user in Germany. the parameter value is coming over as "okt" instead of "oct".

 

I'm wondering whether or not your solution will work in this case!