Forum Discussion
edit custom column
i have create a custom column that consist of all the date range.
How do i edit the custom column now? I tried going back to it but i can't seem to find the way to edit or see the formula.
Can anyone advice? Thank you.
Anonymous
Home >> Edit Queries > Edit Queries >> select the table (Ex:- Table)
Double Click on the "Added Custom" step in the right side.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
10 Replies
Anonymous
Home >> Edit Queries > Edit Queries >> select the table (Ex:- Table)
Double Click on the "Added Custom" step in the right side.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
step 1)Go to "Home-> Locate Table Name at left -> Click on (...) which is for more options in frant of table name -> Select Edit Query option",as below
Step 2) Select the "Gear icon present in frant of added custom step", as below
You can edit your custom column here,as shown below
Hope this will help you...
Hi Anonymous ,
You need to go back to Power Query. Look for the name of the column in the box on the right side of the screen. You can click on the little gear icon to open up the input box for that item.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielNathaniel_C
I still could not locate, could you provide some picture. Thanks so much.Hi Anonymous ,
Sure, in Power BI click on home tab, then Edit Queries. Takes you to Power Query. On the right side of the screen you will find the list of steps. You can click through them all, but more quickly if you click on a gear icon, you will see the input form for that step. What you are looking for is the step that you created the custom column, and then click on that gear to bring up what you filled in on the form to create the column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
There are two simple ways to edit:
- Select the column in the "Fields"options:
If its helps, pls give me a kudo
mauriciosotero I tried clicking the field but the forumla bar dont show anything? right click also show nothing?
Hi Anonymous ,
If you have written that formula in Power BI desktop(Calculated column under modelling section), then go to the repective table and click on Calculated column icon and It will show you the Formula in Formula bar (DAX code)
If you have written this formula in Power query editor, then go to Custom column and you will see a GUI where you can edit the code, If you want. You can also go to Power Query Editor -> View->Advanced editor to look for that formula. For doing this, click on the table (Queries) from left hand side then only select the advanced editor from View.
Note: If you are not seeing formaula bar, tehn you have to tik the checkbox "Formula bar" under view section.
Regards,
Amit
