+ Reply to Thread
Results 1 to 3 of 3

Formula to report Powerquery source

  1. #1
    Forum Contributor
    Join Date
    08-04-2010
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    110

    Formula to report Powerquery source

    I'm using PowerQuery to report an ever changing set of data over a series of tables.
    This is then reported on a reconciliation front page.
    I've labelled the tables per side and currency, so we'll have as an example
    ExternalAUD
    InternalAUD
    ExternalGBP
    InternalGBP
    Now, I want to be able to report these sources next to the data on the front sheet, is there a way to do this via a formula?
    Or maybe another, better way?

  2. #2
    Forum Contributor
    Join Date
    08-04-2010
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    110

    Re: Formula to report Powerquery source

    Don't worry, I added custom columns to my Powerquery and specified the things I wanted in those.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Formula to report Powerquery source

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Excel / powerquery formula to compare dates/time when other value is matching.
    By B4dTweety in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2019, 10:15 AM
  2. Replies: 1
    Last Post: 05-11-2018, 02:54 PM
  3. [SOLVED] How to create report through vb script using an excel data source
    By roofi in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-01-2016, 03:37 PM
  4. PowerQuery - how to get source settings?
    By illusionek in forum Excel General
    Replies: 0
    Last Post: 04-10-2015, 04:12 AM
  5. Quickly Change Report Data Source
    By tampaC66 in forum Access Tables & Databases
    Replies: 11
    Last Post: 03-31-2015, 09:21 PM
  6. Excel could not get the source data for the PivotTable report from the disk
    By GinasGoodies in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-03-2012, 06:22 PM

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