温馨提示:本文翻译自stackoverflow.com,查看原文请点击:powerbi - Power BI, Power Query
powerbi powerquery

powerbi - Power BI,Power Query

发布于 2020-04-05 00:40:54

我有一个清单,例如:

A
B
C
D

现在,我想在电源查询中创建一个查询,该查询将创建如下文本:

“这些信件是:” ABCD

我已经有了这个查询:

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

但是结果只说“ FALSE”

查看更多

提问者
sofboy
被浏览
127
Aleksei Zhigulin 2020-01-31 22:58

您在找这个吗?

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