—这工作,但给我的LATEstrongTATE 45的所有行AddColumns(Sort(TABLE_A,UPDATED_ON,降序),MyDemoColumn",First(Sort(Filter(TABLE_B,PRIMARY_ID = 45),UPDATED_ON,降序)).LATEstrongTATE)
——这不是AddColumns(Sort(TABLE_A,UPDATED_ON,降序),"MyDemoColumn",First(Sort(Filter(TABLE_B,PRIMARY_ID = TABLE_A[@PRIMARY_ID]),UPDATED_ON,降序)).LATEstrongTATE)
where TABLE_B有一个指向表a的外键引用(Many to One)
在使用@
时是否语法错误?更新8/25我还尝试了以下方法。它工作,但给我错误的值AddColumns(Sort(TABLE_A,UPDATED_ON,降序),MyDemoColumn",First(Sort(Filter(TABLE_B,PRIMARY_ID = ThisRecord.PRIMARY_ID),UPDATED_ON,降序)).LATEstrongTATE)
您可以使用As
命令来消除两个PRIMARY_ID
字段的歧义:
AddColumns(
Sort(TABLE_A, UPDATED_ON, Descending) As TA,
"MyDemoColumn",
First(
Sort(
Filter(TABLE_B, PRIMARY_ID = TA.PRIMARY_ID),
UPDATED_ON,
Descending
)
).LATEST_STATE
)