edit custom column

[Anonymous]

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]

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

[Anonymous]

Thank you so much, everyone.

I finally found the edit custom column. 

[Anonymous]

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...

[venal · Accepted solution]

@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?

[mauriciosotero]

There are two simple ways to edit:

- Select the column in the "Fields"options:

If its helps, pls give me a kudo

[Anonymous]

@mauriciosotero I tried clicking the field but the forumla bar dont show anything? right click also show nothing?

[Nathaniel_C]

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.
Nathaniel

[Anonymous]

@Nathaniel_C 
I still could not locate, could you provide some picture. Thanks so much.

[Nathaniel_C]

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

[Nathaniel_C]

Hi @Anonymous , just to let you know I will be going off line in 15 min. However I will check tomorrow. Nathaniel