Forum Discussion

amikm's avatar
amikm
Helper V
5 years ago
Solved

DATATABLE DAX is giving syntax error

I am using the below DAX: Custom = DATATABLE( "Name", STRING, "Code", INTEGER, "ID", INTEGER, { {​​​"WW AA",101,1}​​​, {​​​"WW BB CC",102,2}​​​ } )  I am getting the below error, at first glance...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi amikm 

    There are some non-printing characters between the { and " before the W.

    If you put your cursor before the { then move it right,it takes more than 2 moves to get past the "

    Same problem at the end of both lines where you are declaring the data values.  I've highlighted in red where there are hidden chars that you need to delete

    Delete the {" and retype these characters, same for the end of the data lines.

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi amikm 

There are some non-printing characters between the { and " before the W.

If you put your cursor before the { then move it right,it takes more than 2 moves to get past the "

Same problem at the end of both lines where you are declaring the data values.  I've highlighted in red where there are hidden chars that you need to delete

Delete the {" and retype these characters, same for the end of the data lines.

Regards

Phil

amikm's avatar
amikm
Helper V
5 years ago

Thanks PhilipTreacy  for the catch, I was using Notepad++, now able to fix the issue