Power Query Source from another active Power Query RRS feed

  • Question

  • How can I get data from one query to another ?

    For example I have Query1 that is a table displayed in a worksheet and I want to create a new Query2 and start from the same table that is displayed.

    Can I do this inside Power query or do I have to use Source current workbook ? (in case if I dont want to load that table in to worksheet)

    Duplicating the query is not an option, I still want to be able to modify Query1 without having to worry much about replicating the same in Query2.

    My original gole is to have Query1 displaying data and Query2 displaying Total Rows.
    Do you know another efficient way of adding total rows to a table that will not disappear after table refresh ?
    My totals are functions and need to use COUNTIFs.

    Tuesday, July 14, 2015 10:00 AM


All replies