let
    Source = Json.Document(Web.Contents("https://www.binance.com/fapi/v1/depth?symbol=BTCUSDT&limit=1000")),
    toTable = Table.FromRecords({Source}),
    merge = Table.CombineColumns(toTable, {"bids", "asks"}, (x) => Table.FromRows(List.Transform(List.Zip(x), List.Combine), {"bids.1", "bids.2", "asks.1", "asks.2"}), "temp"),
    result = Table.ExpandTableColumn(merge, "temp", {"bids.1", "bids.2", "asks.1", "asks.2"})
in
    result

objShell.Namespace((sZIPFileName)).CopyHere sFileToZIP, 4

=--SUBSTITUTE(REGEXEXTRACT(INDEX(IMPORTDATA("https://www.mxc.com/api/platform/spot/market/symbol?symbol=MX_USDT"); 1; 34); "\d+(?:\.\d+)?"); "."; ",")

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Салон] <> null)),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Пользовательский", each if [Сумма] = null then [Столбец1] else null),
    #"Filled Down" = Table.FillDown(#"Added Custom",{"Пользовательский"}),
    #"Filtered Rows1" = Table.SelectRows(#"Filled Down", each ([Сумма] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows1",{"Кол-во продаж"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Столбец1]), "Столбец1", "Сумма", List.Sum)
in
    #"Pivoted Column"

= Var groupFilter = CALCULATETABLE('abc'; ALLEXCEPT('abc'; 'abc'[date_2]; abc[Market]; abc[Otd]; abc[Supply]))
Var groupSum = CALCULATE(SUM('abc'[Sellps_2,]); groupFilter)
Var curVal = 'abc'[Sellps_2,]
Var moreOrEqualSum = CALCULATE(SUM('abc'[Sellps_2,]); FILTER(groupFilter; 'abc'[Sellps_2,] >= curVal))
Var pct = moreOrEqualSum / groupSum
Return SWITCH(TRUE();
   pct <= 0,8; "A";
   pct <= 0,95; "B";
   "C"
)