Delay表:
Delay = UNION(
ROW("ID",1,"DelayType","10 Mins"),
ROW("ID",2,"DelayType","15 Mins"),
ROW("ID",3,"DelayType","20 Mins"),
ROW("ID",4,"DelayType","25 Mins"),
ROW("ID",5,"DelayType","30 Mins")
)
Controllable表:
Controllable =
UNION(
ROW("ID",1,"Status","Controllable"),
ROW("ID",2,"Status","Uncontrollable")
)
使用CROSSJOIN实现交叉连接:
CROSS JOIN table = CROSSJOIN(
SELECTCOLUMNS(
'Controllable',
"Status",'Controllable'[Status]
),
SELECTCOLUMNS(
'Delay',
"DelayType",'Delay'[DelayType]
)
)