Forum Discussion
dirkjs
7 years agoFrequent Visitor
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...
dirkjs
6 years agoFrequent Visitor
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
6 years agoFrequent Visitor
The same is true for the DATETIME function. Add a space before the comma like below and the problem is solved.