Add Custom Column Broken - How to solve?

[Anonymous]

Hi all,

I've run into this problem a few times whilst trying to add a custom column in Power Query editor. Has anyone got a fix for this? I can't type see the right hand side of the box, making code a pain to write.

Kind regards,

Jordan 

[Fowmy]

@Anonymous 

Working on coding in Formula bar and in the Advanced Editor is another option. Advanced Editor makes it more convenient.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Pragati11]

Hi @Anonymous ,

I just tried this at my end, but I don't see such issue.

As sonn as there is no space on 1st link, the cusor by default gows to the 2nd line by allowing me to write the code there.

In the highlighted section below, I continued writing the code and the curson went by-itself to next line.

See below:

Are you on the latest version of Power BI Desktop?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11,

I know it goes to a second line, but you'll notice that the available columns reaches far into my textbox. 

Kind regards,

Jordan

[Greg_Deckler]

@Anonymous - Do you have an excessively long column name by chance? Scroll down through your list of available columns.

[Anonymous · Accepted solution]

@Greg_Deckler I do yes, it appears that this is infact the issue and it will be fixed in the October release.

https://community.powerbi.com/t5/Issues/long-column-names-cause-overlap-in-the-Custom-Column-formula... 

[Pragati11]

Hi @Anonymous ,

Yes seems to a weird issue. 

Thanks,

Pragati

[FarhanAhmed]

which version of desktop are you using ?

haven't faced such issue in August 2020 update.

[Anonymous]

Hi @FarhanAhmed, I'm also using August 2020 and have had this many times!

Kind regards,

Jordan  

[amitchandak]

@Anonymous , press ESC, and try. But should report as an issue or idea

https://ideas.powerbi.com/ideas/

https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

raised as issue!

https://community.powerbi.com/t5/Issues/Add-Custom-Column-Broken/idi-p/1351736#M60592