Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
1 year ago
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"}...
General Comment
  • Deku's avatar
    Deku
    1 year ago

    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"}}
    )  

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi Dicken ,

Try this DAX expression: 

Dtable =
DATATABLE (
"dDate", DATETIME,
{
{ DATE(2020, 1, 1) + TIME(0, 0, 0) }
}
)