Forum Discussion

dirkjs's avatar
dirkjs
Frequent Visitor
7 years ago

Incorrect syntax for DATETIME

I get an incorrect syntax error for the DATETIME strings in the example below: CustomFiscalPeriods = DATATABLE ( "Fiscal YearNumber", INTEGER, "FirstDayOfYear", DATETIME, "LastDayOfYear", DATE...
Need Help
dirkjs's avatar
dirkjs
Frequent Visitor
6 years ago

I have more syntax errors! This file is from the website Power BI Tips & Tricks, 

File – DAX Date Tables PBIX

See the following screen shot!

Error, Bug

dirkjs's avatar
dirkjs
Frequent Visitor
6 years ago

I could find it. It is really a BUG in Power BI or even DAX. If I add a space before the comma seperator like you see below, there are no syntax errors anymore! So Microsoft developpers, you know what to do.

  • dirkjs's avatar
    dirkjs
    Frequent Visitor
    6 years ago

    The same is true for the DATETIME function. Add a space before the comma like below and the problem is solved.