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
pbeye's avatar
pbeye
Resolver II
7 years ago

Can you post a screen shot of what you see? It workes fine for me which is weird. You're trying to create a new table and not a column, correct?

dirkjs's avatar
dirkjs
Frequent Visitor
7 years ago

That is true. I try to create a table with 3 columns.

Incorrect Syntax for DATETIME

  • dirkjs's avatar
    dirkjs
    Frequent Visitor
    7 years ago

    This is something for Power BI Development Team. I tried to comment the second field and I got the following strange result!Second field as a comment.

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      7 years ago

      hi, dirkjs 

      Could you try my sample pbix to check it if works well.

       

      Best Regards,

      Lin

       

      • dirkjs's avatar
        dirkjs
        Frequent Visitor
        7 years ago

        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.