Error: convert the value to type List.

[mb0307]

Hi

Here is a table called FridayTable

and this is my code to concatenate a column values into one line text here:

{Cube.ApplyParameter, "[!V000004]", {"""" & Text.Combine(FridayTable[DateCol],""", """) & """" }},

and Error I get:

How can I fix this?

Thanks a lot.

[mb0307 · Accepted solution]

Thank you and other for looking into this but I have managed to find alrenative solution that worked.

{Cube.ApplyParameter, "[!V000004]", {{ #"Date1" & "", "" & #"Date2" & "", "" & #"Date3" }}},

Date1, Date2 and Date3 are separate queries of text type. 

Thanks again.

[goncalogeraldes]

Hello there @mb0307 ! The solution I am gonna give is not a good pratice since you should always provide a specific type of data for a column. Nevertheless, try the following:

= Table.TransformColumnTypes(#"Previous Step",{{"Column Name", type any}})

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[CNENFRNL]

Keep the format of [DateCol] as text, then

Text.Combine(FridayTable[DateCol], ", ")

[mb0307]

@CNENFRNL Thanks.  New error:

Expression.Error: We cannot convert the value "20200731, 20200828, ..." to type List.
Details:
Value=20200731, 20200828, 20200925, 20201030, 20201127, 20201225, 20210129, 20210226, 20210326, 20210430, 20210528, 20210625, 20210730, 20210827, 20210924
Type=[Type]

[BA_Pete]

Hi @mb0307 ,

Try putting curly braces around your column reference:

Text.Combine( {FridayTable[DateCol]} ,""", """)

Pete

[mb0307]

@BA_Pete  Thanks but now I get this error

Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]

[BA_Pete]

Ok, try this:

Text.Combine( {Text.From(FridayTable[DateCol])} ,""", """)

Pete

[mb0307]

@BA_Pete  Same error again.