将以下语法输入到下面在 Excel(Office 365 版本)的 powerpivot 中提供的表 Visits 的计算列公式中:
=GROUPBY(
Visits,
[Patient Name],
"First_Visit_Date",
MINX(CURRENTGROUP(), Visits[Visit_Date])
)
产生错误:
The expression refers to multiple columns. Multiple columns cannot be
converted to a scalar value.
使用 Excel 中嵌入的 PowerPivot 将计算列“First_Visit_Date”添加到下面描述的简单源表访问表以到达下面也列出的目标表时,正确的 DAX GROUPBY 语法是什么:
来源表(访问量):
Patient_Name, Visit_Date, Duration
Sue, 8/10/2017, 60
Sue, 8/12/2017, 20
Sue, 8/20/2017, 15
Bill, 9/ 1/2018, 90
Bill, 10/ 1/2018, 90
Sally, 5/22/2016, 30
Sally, 5/30/2016, 30
目标表:
Patient_Name, Visit_Date, Duration, Calculated Column 1
Sue, 8/10/2017, 60, 8/10/2017
Sue, 8/12/2017, 20, 8/10/2017
Sue, 8/20/2017, 15, 8/10/2017
Bill, 9/ 1/2018, 90, 9/ 1/2018
Bill, 10/ 1/2018, 90, 9/ 1/2018
Sally, 5/22/2016, 30, 5/22/2016
Sally, 5/30/2016, 30, 5/22/2016