自定義函數(shù)
自定義函數(shù)：
(參數(shù)1，參數(shù)2，參數(shù)3……) => 函數(shù)運算表達式
※通過調(diào)用函數(shù)得到的函數(shù)返回值稱為函數(shù)值
例：
(parameter1 as number, parameter2 as number) =>
let
Final = (parameter1 + parameter2) / 2
in
Final

If表達式
if表達式通過對邏輯條件進行判斷來對兩個表達式進行選擇。
例：
if 2 > 1 then
2 + 2
else if 2 = 1 then
2 + 1
else
1 + 1

創(chuàng)建表格
let
源 = #table(
{"訂單id","客戶id","訂單金額"},
{
{"a","aa",100},
{"b","bb",200},
{"c","bb",300}
}
)
in
源


let
源 = #table(
{"客戶id","客戶名稱"},
{
{"aa","趙大"},
{"bb","王二"}
}
)
in
源

let
源 = [
訂單id = "b",
客戶id = "bb",
訂單金額 = 200,
客戶表 = #table(
{"客戶id","客戶名稱"},
{
{"bb","王二"}
}
)
]
in
源