Forum Discussion

amikm's avatar
amikm
Icon for Helper V rankHelper 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

amikm's avatar
amikm
Icon for Helper V rankHelper V
5 years ago

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