Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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, I am not able to see any error in my code, not sure, why I am getting below error
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Thanks @PhilipTreacy for the catch, I was using Notepad++, now able to fix the issue
Try VS Code
Visual Studio Code - Code Editing. Redefined
Regards
Phil
Proud to be a Super User!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.