Hi,
I am trying to dynamically transform column data, but having trouble. I have list of column names I want to change called "Blanks". I want to convert those columns to nulls, but getting an error message on the formula.
Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=
I am trying to dynamically transform column data, but having trouble. I have list of column names I want to change called "Blanks". I want to convert those columns to nulls, but getting an error message on the formula.
Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=
Type=[Type]
This is my Formula:
= Table.TransformColumns(#"Sorted Rows",{{(Blanks), each null}})
Thanks for the help!