问题描述
非常类似于这个,而且我会评论询问@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:如何连接多个分组值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!