topic Re: If statement gives error token leftbracket expected in DAX Commands and Tips

If statement gives error token leftbracket expected

JimT99 — Tue, 03 May 2022 18:32:02 GMT

Im getting a token leftBracket expected error:
I'm trying to add a "0" to the end of the field LotTxt if the length of the text is not 10.

Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")

Re: If statement gives error token leftbracket expected

tackytechtom — Tue, 03 May 2022 19:03:25 GMT

Hi JimT99 ,

Could the left bracket error come from here. It seems like there is a double open bracket:

Here your code with the bracket in bold:

Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Re: If statement gives error token leftbracket expected

JimT99 — Tue, 03 May 2022 19:11:24 GMT

yes...that was it. (Embarassed). Now it tells me that "If" isn't recognized.

Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly.

Re: If statement gives error token leftbracket expected

tackytechtom — Tue, 03 May 2022 19:22:29 GMT

Hi JimT99 .

Not sure why it says this, but when I pasted your formular into my PBI the CONCATENATE function also had some small issue.

Can you try it with the following syntax?
Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[LotTxt], CONCATENATE(grading_data[LotTxt],"0"))

Let me know if this helps and do not forget to mark the answer 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/