PQ参考M Code

let
    url = "http://query.sse.com.cn/commonQuery.do?&jsonCallBack=jsonpCallback97061&isPagination=false&sqlId=COMMON_SSE_GP_SJTJ_DQHYFL_ADQFL_MX_L&areaname=2&_=1588303208749",
    referer = "http://www.sse.com.cn/assortment/stock/areatrade/area/detail.shtml?AREANAME=2",
    headers = [#"Accept-Language"="zh-CN,zh;q=0.9",Referer=referer,Cookie = "yfx_c_g_u_id_10000042=_ck20032318483317775311077916017; VISITED_COMPANY_CODE=%5B%22601118%22%2C%22600968%22%5D; VISITED_STOCK_CODE=%5B%22601118%22%2C%22600968%22%5D; VISITED_MENU=%5B%228466%22%2C%228536%22%2C%228537%22%2C%228535%22%2C%229055%22%5D; yfx_f_l_v_t_10000042=f_t_1584960513687__r_t_1588301561018__v_t_1588303208041__r_c_1"],
    wodata = Web.Contents(url, [Headers = headers]),
    result = Table.FromRecords(Json.Document("["&Text.BetweenDelimiters(Text.FromBinary(wodata),"(",")")&"]"){0}[result])
in
    result

PQ参考解法

let
    销售 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    成本 = Excel.CurrentWorkbook(){[Name="表2"]}[Content],
    结果 = Table.CombineColumns(Table.DuplicateColumn(Table.NestedJoin(销售, {"产品"}, 成本, {"产品"}, "table", JoinKind.LeftOuter), "日期", "CompareDate"),
            {"table","CompareDate"},each Table.Sort(Table.SelectRows(_{0},(x)=>x[日期]<=_{1}),{"日期",Order.Descending})[金额]{0}?,"金额")
in
    结果

= Text.Contains("AB. C",". *")

http://club.excelhome.net/thread-1533545-1-1.html

=FORMAT(DATE(2020,4,22),"dddd")

扩展下

(getList as list,selectCount as number)=> //getCombination 求指定列表给定个数的所有非重复组合
[getListIndex=List.Transform(List.Positions(getList),each _+1),
 getCombinations=List.Accumulate({1..selectCount-1},List.Zip({getListIndex}),(s,c)=>
    List.TransformMany(s,each List.Range(getListIndex,_{c-1}),(x,y)=>x&{y})),
 result=List.Transform(getCombinations,(x)=>List.Transform(x,(y)=>getList{y-1}?))
][result]

黑==黑色？Text.Contains