Forum Discussion

GoatTracker's avatar
GoatTracker
Frequent Visitor
2 years ago
Solved

Add as new query from existing query

Hi brains trust,   I've Grouped by the ID field and want to dynamically create a new query from the Table it generates per Project. At present, I have to right-click each row's Table and select "Ad...
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi GoatTracker ,

     

    If you really want to follow this course then I think VBA is your best/only bet.

    Power Query can't spawn new queries itself and anything we could do to make this happen would be very fiddly, and neither particularly dynamic nor robust.

    Have you considered having just one generic Project tab that you change the data in using a pivot slicer against your main project table?

     

    Pete

     

BA_Pete's avatar
BA_Pete
Super User
2 years ago

Hi GoatTracker ,

 

If you really want to follow this course then I think VBA is your best/only bet.

Power Query can't spawn new queries itself and anything we could do to make this happen would be very fiddly, and neither particularly dynamic nor robust.

Have you considered having just one generic Project tab that you change the data in using a pivot slicer against your main project table?

 

Pete