Item column exists but still getting error

[bzeeblitz]

Item:# exists in the ab table but then im getting error cannot find name [Id:#]

[Bipin-Lala · Accepted solution]

Hi @bzeeblitz,

Highly likely that special characters a # may not be recognized correctly in DAX expressions as @lbendlin  mentioned. I would have confirmed the same if I was near my laptop.

• Also, refer to the following post - https://community.fabric.microsoft.com/t5/Power-Query/Special-Character-in-Column-Name/td-p/2321919 where user mentioned that special characters like # do cause troubles with Power Query.

[lbendlin]

Most likely you tripped the code parser.  Try using some less inventive column names. No :, no # etc.