Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query Editor - Can a query source be another loaded query? as opposed to the source file

Hi All   Some power query support required!   In my queries, i need to build pivot versions of my source data, while retaining the source data itself for various visualisation in my report.   T...
  • mahoneypat's avatar
    6 years ago

    Yes.  That is exactly what the Reference feature is.  When you right click on a query to Duplicate it, choose Reference instead.  It uses the output of one query as the input of the new one.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat