Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago
Solved

Error: convert the value to type List.

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(FridayTab...
Need Help
  • mb0307's avatar
    mb0307
    4 years ago

    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's avatar
goncalogeraldes
Super User
4 years ago

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