Form-styled new column popup shows instead of standard new column formula popup

[benjamin_sasin]

First I create a new column with this standard popup where I can type my formula:

But then ehwn I want to edit the column, I'm getting this annoying format:

How can I edit using the classic formula screen, I just want to to code. This popup is not adequate at all.

Any setting I should change?

[v-xicai]

Hi @benjamin_sasin   ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[benjamin_sasin]

Hi,

This is not what I mean.

I clearly added a custom column by typing code in the code input area of the standard new colum prompt. However, because I typed an IF...THEN clause, when I click on the same step to edit, it show a conditional column prompt.

This is something new to PowerBI. I just want to edit the code and not fiddle around with drop downs and what not.

[v-xicai · Accepted solution]

Hi @benjamin_sasin ,

Yes, I can reproduce your issue using IF function to create custom column.  If you need to see and edit the codes, just click the step "Add custom" , then go to View-> Formula Bar.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@benjamin_sasin , if you click of a custom column name in the table , the formula bar should show it calculation in edit query mode?

[benjamin_sasin]

Yes it shows the forumula bar. However the formula bar format is not the same as the pop up format as well as the popup offers predictive text where the formula bar doesn't.

[v-xicai]

Hi @benjamin_sasin ,

Generally , when you click "Custom Column" button, pop-up page is like picture one, and when you click "Conditional Column" button, pop-up page is like picture two. 

Then it will appear the steps like names below. While the "Conditional Column" pop-up page appears in step "Added Custom1" in your scenario, you may check if you have renamed the step name  "Added Conditional Custom" with "Added Custom1"  in APPLIED STEPS pane.  or you may create a custom column again.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.