如何执行NATURALLEFTOUTERJOIN没有在两个表中具有相同的名称?

Question

我尝试在两个表中创建相同的列，但最终收到错误"检测到不兼容的连接列，(" [WeekName])。'NATURALLEFTOUTERJOIN'不支持使用不同数据类型的列或linee"进行连接。

LeftOuterJoin = NATURALLEFTOUTERJOIN(
SELECTCOLUMNS(GROUPBY(DateTime,DateTime[yDayFullName],
"WEEKCOUNT", COUNTX(CURRENTGROUP(),DateTime[yDayFullName])),
"WeekName", DateTime[yDayFullName], "WEEKCOUNT",[WEEKCOUNT]),
SELECTCOLUMNS(GROUPBY(FILTER(Mergetable,Mergetable[noShow]<>"true"),Mergetable[WeekDayName],
"TOTALDURATION", SUMX(CURRENTGROUP(),Mergetable[MeetingDurationInHours])),
"WeekName",Mergetable[WeekDayName],"TOTALDURATION",[TOTALDURATION]))

Answer 1

你能不能把代码改成下面的样子，看看能不能用

"WeekName", DateTime[yDayFullName]&""和

"WeekName",Mergetable[WeekDayName]&""

同时，请确保DateTime[yDayFullName]和Mergetable[WeekDayName]具有相同的数据类型。

我假设它们都是字符串，我猜你是想在WeekName上加入。