[PowerBI]DAX-DATABLE関数を使用してStaticテーブルを作成する


index name t age
1 a 20211109 10
2 b 20211109 20
3 c 20211109 30
4 d 20211109 40
  • 周辺機器データを使用したDAX文の作成
    =CONCATENATE("{", A2, ", """, B2, """, """, C2, """, ", D2, "},")
  • T = DATATABLE (
        "index", STRING,
        "name", STRING,
        "t", DATETIME,
        "age", INTEGER,
        {
            {1 , "a", "2021-11-09", 10},
            {2 , "b", "2021-11-09", 20},
            {3 , "c", "2021-11-09", 30},
            {4 , "d", "2021-11-09", 40}
        }
    )
    DOUBLE
    https://www.sqlbi.com/articles/create-static-tables-in-dax-using-the-datatable-function/