Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.