power query M table

背景
投稿者投稿者ZUKUいいね0お気に入り登録
プレイ回数8難易度(4.5) 60秒 英語 英字

問題文

ふりがな非表示 ふりがな表示

(Table.FromList( {list}, Record.FieldValues, {"CustomerID", "Name"}))

Table.FromList( {list}, Record.FieldValues, {"CustomerID", "Name"})

(Table.AddColumn( table, "TotalPrice", each [Price] + [Shipping], type number))

Table.AddColumn( table, "TotalPrice", each [Price] + [Shipping], type number)

(Table.AddIndexColumn( table, "Index"))

Table.AddIndexColumn( table, "Index")

(Table.AddJoinColumn( Table, "saleID", () => Table, "saleID", "price"))

Table.AddJoinColumn( Table, "saleID", () => Table, "saleID", "price")

(Table.AddRankColumn( Table, "name", {"c", Order.Descending}, [RankKind = RankKind.Competition]))

Table.AddRankColumn( Table, "name", {"c", Order.Descending}, [RankKind = RankKind.Competition])

(Table.AggregateTableColumn( Table, "t_col_name", { {"a", List.Sum, "sum of t.a"}, }))

Table.AggregateTableColumn( Table, "t_col_name", { {"a", List.Sum, "sum of t.a"}, })

(Table.ColumnNames( Table))

Table.ColumnNames( Table)

(Table.ColumnsOfType( Table, {type number}))

Table.ColumnsOfType( Table, {type number})

(Table.Combine({ tables as list}))

Table.Combine({ tables as list})

(Table.CombineColumns( T, {"c1", "c2"}, Combiner.CombineTextByDelimiter(",", QuoteStyle.None), "c12"))

Table.CombineColumns( T, {"c1", "c2"}, Combiner.CombineTextByDelimiter(",", QuoteStyle.None), "c12")

ピックアップ

タイピング練習講座 ローマ字入力表 アプリケーションの使い方 よくある質問

人気ランキング

注目キーワード