+ Reply to Thread
Results 1 to 2 of 2

Is there a way to add a normal excel formula to a Power Query Table

  1. #1
    Registered User
    Join Date
    03-05-2011
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    84

    Is there a way to add a normal excel formula to a Power Query Table

    Im refreshing excel files that are updated in a folder. Is it possible to add 2 additional columns with formulas after the table loads. The first formula trims off www.domain.com text from a URL column and the second one is an ifblank, display another column formula.

    I think I can do the ifblank one with power query but I dont know how to format the URL's without RIGHT FIND LEN formulas. Also just wondering in general as I have other tables that would be easier if I could somehow reference the excel formulas after the load.

    I tried putting the columns next to the power query load but it just overwrote/deleted them.

  2. #2
    Registered User
    Join Date
    03-05-2011
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    84

    Re: Is there a way to add a normal excel formula to a Power Query Table

    I think b/c i added the columns before I wrote the query it wasnt working. After the query loaded i just added two columns to the table and they stayed without deleting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM
  2. Exporting Facebook group comments to Excel using Power Query?
    By trapperjohn22 in forum Excel General
    Replies: 2
    Last Post: 02-27-2016, 04:12 AM
  3. Excel Crash when trying to use Power Query
    By Bikashmittle in forum Office 365
    Replies: 2
    Last Post: 02-03-2016, 11:22 AM
  4. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM
  5. Replies: 2
    Last Post: 07-19-2015, 06:04 PM
  6. [SOLVED] Fixed reference for column in a table formula, like $ in normal excel
    By taranaki88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2013, 03:47 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1