Forum Discussion
Solved
DAX DATATABLE
Hi, I don't think the data type DATETIME availabel in DATATABLE works, as in a date time should work as a date / time but Dtable = DATATABLE( "dDate" ,STRING, { {"01/01/2020"}...
Ran it on my machine. That function does not seem to like non hard coded values. This worked
Dtable =
DATATABLE(
"dDate", DATETIME ,
{{"01/01/2020"}}
)
This should work add a extra {} for the row
Dtable =
DATATABLE(
"dDate", DATETIME ,
{{DATE(2020,1,1)}}
)
I don't know if you got it to work but I get this ;
The tuple at index '1' from the table definition of the DATATABLE function does not have a constant expression in the column at index '1'