Forum Discussion
Duplicating a step in Power Query
Is there any way to copy and paste a step *within* a query, and then edit the second step? This seems so basic, but I have not found a way to do this.
3 Replies
open Advanced Editor and do whatever you want.
Thanks, I did try that and it was giving me a number of errors (clearly I need to learn more about the syntax). Missing tokens, etc. For the simple 'replace' values I was trying to do, it was not simple.
For Find and Replace, often it is easier to use your favorite Text Editor or IDE, and then
bring it back into the Advanced Editor. Methods may vary.
I thought you may be interested in a few best practice resources that I skimmed the top off of the pile:
- Enterprise DNA Youtube Channel: Ultimate Beginners Guide to Power BI (Playlist) - updated 5 days ago
- Microsoft Learn: https://learn.microsoft.com/en-us/power-query/best-practices
- Zerbra Blog: Power Query Best Practices | Zebra BI Knowledge Base
- Paul Turley Blog: https://sqlserverbi.blog/2021/02/14/doing-power-bi-the-right-way-4-power-query-design-best-practices/
- Goodly Youtube: 5 Best Practices in Power Query
- Wyn Hopkins / Access Analytic YouTube
- Chandoo: Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download
- Mynda Treacy YouTube Channel
- Michael Girvin ExcelIsFun YouTube Channel
