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.

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi mb0307 ,

 

Try putting curly braces around your column reference:

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

 

Pete

mb0307's avatar
mb0307
Responsive Resident
4 years ago

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

     

    Ok, try this:

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

     

    Pete

    • mb0307's avatar
      mb0307
      Responsive Resident
      4 years ago

      BA_Pete  Same error again.