PowerQuery:如何连接多个分组值 [英] PowerQuery: How can I concatenate MULTIPLE grouped values

问题描述

非常类似于这个，而且我会评论询问@marc-pincince，但我没有声誉要求.

Very similar to this, and I would comment to ask @marc-pincince but I don't have the reputation require.

这是否适用于 3 列数据?我有 A、B、C 列.

Would this be adaptable for 3 columns of data? I have column A, B, C.

• A = ID
• B = 奖
• C = 年

我需要的是新列 A 将所有 ID 分组，然后新列 B 显示 Award Year、Award Year、Award Year、Award Year 等.

What I need is to have new column A which groups all the ID's and then new column B which shows Award Year, Award Year, Award Year, Award Year , etc..

我尝试使用自定义列使用 =[AllData][Award][Year]还尝试使用 =[AllData]([Award]+[Year])

I tried using The Custom Column using =[AllData][Award][Year] Also tried using =[AllData]([Award]+[Year])

这两种情况都会导致错误.我能够让 [AllData][Award] 和 [AllData][Year] 单独工作.

Both of these result in errors. I was able to get [AllData][Award] and [AllData][Year] to work seperately.

你有什么想法吗?

谢谢，杰克

推荐答案

您需要创建一个将 Award 和 Year 连接在一起的列.为此，请确保这两列都是文本数据类型，然后使用公式 = [Award] & 创建自定义列 [AwardYear]" " &[年份].

You'll need to create a column that concatenates the Award and Year together. To do this, make sure both of those columns are a text data type and then create a custom column [AwardYear] using the formula = [Award] & " " & [Year].

完成此操作后，您可以按照与其他问题相同的步骤进行操作，但您将使用 [AllData][AwardYear] 作为自定义列.

Once you do that, you can follow the same steps as in the other question, except you'll use [AllData][AwardYear] for your custom column.

这篇关于PowerQuery:如何连接多个分组值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！