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.

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago

Keep the format of [DateCol] as text, then

Text.Combine(FridayTable[DateCol], ", ")
  • mb0307's avatar
    mb0307
    Responsive Resident
    4 years ago

    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]