Forum Discussion
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...
Dear Lin,
Thanks for your kind support. When I load your demo.pbx, the database is created and loaded, BUT, the syntax error remains(!) and when I hit one [RETURN] in the formula panel, I loose the data in the tabel like you see in my screenshot below.
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
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.
The same is true for the DATETIME function. Add a space before the comma like below and the problem is solved.