Forum Discussion
Solved
Expression.Error: We cannot convert a value of type Function to type Type.
Hi all, I'm sure it's something obvious but wanted to get a fresh set of eyes. I am getting the error: Expression.Error: We cannot convert a value of type Function to type Type. Details: Va...
It is caused by the following part
{"Constituent Date Added", each Date.From(DateTimeZone.From(_,"en-US"),"en-GB"), type date}
If you want to convert a column using a custom transformation function, you should use Table.TransformColumns instead. so replace Table.TransformColumnTypes with Table.TransformColumns.
You are confusing Table.TransformColumns with Table.TransformColumnTypes.
#"Changed Type1" = Table.TransformColumns(...It is caused by the following part
{"Constituent Date Added", each Date.From(DateTimeZone.From(_,"en-US"),"en-GB"), type date}
If you want to convert a column using a custom transformation function, you should use Table.TransformColumns instead. so replace Table.TransformColumnTypes with Table.TransformColumns.