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
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
6 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
    6 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
      6 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.

      • 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