Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 "Add as new query". This would be painful. ANyone got some adeas to resolve please?
I'm trying to create individual worksheets from a master list by Project, I haven't been able to do this without VBA but if someone has a solution, I'd be happy to see it.
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
65 | |
61 | |
27 | |
17 | |
13 |