+ Reply to Thread
Results 1 to 1 of 1

Power query M code circular reference

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    627

    Power query M code circular reference

    Hi,
    I have a circular dependency but can't see a way around it,



    Please Login or Register  to view this content.

    This is the stating point, but I would like to use the rename option in tablefromrows , but I need to know the number of columns

    So it thought to create a list on names, more than needed and then shorten in depending on the colunn count of the above table;

    New Names =
    Please Login or Register  to view this content.
    and then use this to rename the columns, but as it's dependent on it's self as it were it don't work, the steps referred to are Expand and NewNames in the attached workbook, is there another and better way to approach this?

    Richard
    Attached Files Attached Files

+ 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. Replies: 5
    Last Post: 01-03-2023, 02:48 PM
  2. Replies: 3
    Last Post: 01-08-2022, 05:23 PM
  3. [SOLVED] Power query table reference to another query
    By Undo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2021, 09:41 AM
  4. Replies: 2
    Last Post: 10-06-2020, 04:37 PM
  5. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Circular reference in my code
    By jjking57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2007, 01:15 PM

Tags for this Thread

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