[Power BI] DAX - DATATABLE 함수로 Static table 만들기

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/