Forum Discussion
Expression.SyntaxError: Token RightParen expected. // Needing Help with a custom function
It needs to go at the very end of the line, not in the middle
Community ChampionWe've all done it and you're going to kick yourself when you solve it.
If I said Right paren means right bracket or closing bracket ......
---
As to the algorithm, I have 2 suggestions:
1. Maybe use Add column ->Column from examples to see if powerbi can help.
2. If you don't get it that way, have a look at Text.PadStart() function
Good luck
Thanks for your reply, i'll have a look in your sugestions and about the sugestions
1 - Soo.. i've tried the column from examples and it kinda worked for some values, but not for all fo them. Most because there are some codes that start with 2 zeros.. or 3, or 4 or even that start with 0 and then add a normal number like 1... soo it creates a lot of variants that PBI cant figure out what to do since if it starts with an 0 he automatically discart the number. Also, I could adapt all these variants one by one, but the problem is that pbi in this add column by examples have a limited visualization where i cant solve all of these
2 - the point is using Text.PadStart instead of Text.Insire?