Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 anyo...
Need Help
  • venal's avatar
    venal
    6 years ago

    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?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Thank you so much, everyone.

I finally found the edit custom column.