Results 1 to 4 of 4

Thread: Power Query: Reference specific step of another query
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2014
    Location
    Toronto, Canada
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query: Reference specific step of another query

    Greetings Power Users,

    In Power Query, there is an option to Reference one query in another. So if I have QueryA with 5 steps:

    Source
    Step1
    Step2
    Step3
    Step4

    I can create a new QueryB that references QueryA by setting Source = QueryA. This always makes the starting point of QueryB the final step of QueryA, and updates accordingly if QueryA is changed.

    What I am trying to do is reference Step2 of QueryA and ignore all of the subsequent steps. So the start point of QueryB will be whatever the output of QueryA is as of Step2.

    I doubt this is possible, but the hive might have the answer.

    Thanks,
    Ben

  2. #2
    Board Regular MarcelBeug's Avatar
    Join Date
    Apr 2014
    Posts
    1,811
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query: Reference specific step of another query

    No it is not possible. But you can make one query that ends with step2 and use that as the basis for the additional steps in queries A and B.
    Specializing in Power Query (M).
    Using Excel 2007 (Dutch) and Excel 2016 (Office 365 ProPlus) (Dutch/English), both on Windows 10.
    Array formulas can be recognised by the {} Excel puts around it automatically when you press Ctrl+Shift+Enter upon formula entry.

  3. #3
    Board Regular
    Join Date
    Oct 2014
    Location
    Toronto, Canada
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query: Reference specific step of another query

    Quote Originally Posted by MarcelBeug View Post
    No it is not possible. But you can make one query that ends with step2 and use that as the basis for the additional steps in queries A and B.
    As I expected. But good to have confirmation. Thanks!

  4. #4
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query: Reference specific step of another query

    In addition a to MarcelBeug's comment, if the step you want is mid-query, you could split that query using the split feature creating 2 queries and an end point for the step you need
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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