Reply
mb0307
Responsive Resident
Responsive Resident
Partially syndicated - Outbound

List to text

Hi,

 

I have a List values:

List.jpg

 

I want to use exactly same format with "" shown above in this query:

 

 

{Cube.ApplyParameter, "[!V000004]", {{ #"ListName"}}},

 

 

 

If I provide the ListName then i get this error:

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

 

How can i convert List values to Text and use in my query please?   

keeping the List format with "" like this:

"20200925", "20201030", "20201127", "20201225", "20210129", "20210226", "20210326", "20210430", "20210528", "20210625", "20210730", "20210827", "20210924", "20211029" 

 

Thanks in advance.

3 REPLIES 3
GateJay
Frequent Visitor

Syndicated - Outbound

Hi,

 

I was dealing with same issue and solution was to keep the list in form of list instead of string and to remove one pair of {}.

Working code:

{Cube.ApplyParameter, "[!V000004]", {List1}}

Together with list (square bracket are there because of weird naming convenction we have here):
Screenshot 2023-10-02 171453.png

AlexisOlson
Super User
Super User

Syndicated - Outbound

I'm guessing what you want is this:

{Cube.ApplyParameter, "[!V000004]", {Text.Split(#"ListName"{0}, ",")}},

 

Greg_Deckler
Community Champion
Community Champion

Syndicated - Outbound

@mb0307 How about this?

let
    Source = { " ""20200925"", ""20201030""" },
    Text = Lines.ToText(Source)
in
    Text


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)