Duplicating a step in Power Query

[kwrigh15]

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.  

[kwrigh15]

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. 

[foodd]

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

[AlienSx]

open Advanced Editor and do whatever you want.