- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

List to text
Hi,
I have a List values:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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):
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I'm guessing what you want is this:
{Cube.ApplyParameter, "[!V000004]", {Text.Split(#"ListName"{0}, ",")}},
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-21-2025 08:24 AM | |||
12-12-2023 11:19 AM | |||
05-26-2024 07:36 PM | |||
07-10-2025 03:57 AM | |||
07-10-2025 07:37 AM |
User | Count |
---|---|
14 | |
13 | |
8 | |
6 | |
6 |