Forum Discussion
cannot convert value 1 to text
i am working with power Query on desktop and I have facing this error.Expression.Error: We cannot convert the value 1 to type Text. Details: Value=1 Type=[Type] it is for two specific columns bu...
Hi Anonymous
The below line explicitly converts the GRADE and Status columns to text using Table.TransformColumnTypes before performing any operations on them. This prevents errors when applying text functions like Text.Upper and Text.Trim.
// Convert GRADE and Status columns to Text type to prevent errors #"Converted Columns to Text" = Table.TransformColumnTypes(Source, {{"GRADE", type text}, {"Status", type text}})Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi Anonymous
The below line explicitly converts the GRADE and Status columns to text using Table.TransformColumnTypes before performing any operations on them. This prevents errors when applying text functions like Text.Upper and Text.Trim.
// Convert GRADE and Status columns to Text type to prevent errors
#"Converted Columns to Text" = Table.TransformColumnTypes(Source, {{"GRADE", type text}, {"Status", type text}})
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz