Warm tip: This article is reproduced from stackoverflow.com, please click
powerbi powerquery

Power BI, Power Query

发布于 2020-04-05 00:23:31

I have a list for example:

A
B
C
D

Now I want to create a query in power query that will create a text like this:

"The letters are: " A B C D

I already have this query:

let
    xx=   KEYListfunction(),
    list = Text.Split(xx, ","),
    text = "",
   loop = List.Accumulate(list, 0, (state, current) => text = text &  " " & current ))
in
loop

But the result only says "FALSE"

Questioner
sofboy
Viewed
55
分享
Aleksei Zhigulin 2020-01-31 22:58

Are you looking for this?

let
    list = {"A".."D"},
    text = "The letters are: " & Text.Combine(list, ", ")
in
    text

Related issues

1
Displaying additional data below matrix
2
DAX Filter context
3
DAX: please check if I understood the use of Variabes in DAX correctly
4
DAX
5
Does power BI import mode require more memory compared to direct query and live connection mode?
6
How does CALCULATE apply all the filters?
7
Mapbox Power BI circle drill through
8
Top 10 cost where profit is < zero
9
Datasets storage limit and memory limit in Power BI with respect to compression
10
Wildcard search in the IN operator