Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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")
Solved! Go to Solution.
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")
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")
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!
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?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |