Results 1 to 2 of 2

Thread: Modify formula in custom column Power Query

  1. #1
    Seeker albertan's Avatar
    Join Date
    Nov 2017
    Excel Version

    Modify formula in custom column Power Query

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I appreciate help as I'm new in Power Query world of learning.

    I created a custom column in Power Query with a simple formula. If I'd like to go back and edit this formula, how would I do that. I see the formula in a formula bar but it doesn't look in a structural format (say Column A + Column B = Column C).

    I tried to look up all commands in edit mode but couldn't find how can I get to the window where I initially was setting up the formula in that custom column.

    thank you everyone in advance!

  2. #2
    In the picture below an example: if you click on the gear button at the right of the step name (the one in the red circle), then you get the pop up in the middle.

    Click image for larger version. 

Name:	Adjust formula.png 
Views:	23 
Size:	27.8 KB 
ID:	7602

    Power Query is pretty structured, but maybe in another way then you are used to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts