Add Text edit capacities to the Advance Editor

Hi Teefo ,

For the changes that you are refering currently you have an alternative that is the use of the TMDL viewer that allows you to do the replacement of text, copy queries directly and all those types of things, and add additional steps if needed like the advance editor.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tmdl-view

Concerning the comments part you can do it usgin the // notation before each step of your Power Query so you would get something similar to this:

let
    Source = #table(1, {{CalendarFirstDate}}),
//Define start date for the calendar
    StartDate_Rename = Table.RenameColumns(Source,{{"Column1", "StartDate"}}),
// Define end date for the calendar
EndDate = Table.AddColumn(StartDate_Rename, "EndDate", each  Date.EndOfYear(DateTime.LocalNow())),
    StarEnd_Dates_Format = Table.TransformColumnTypes(EndDate,{{"StartDate", type date}, {"EndDate", type date}}),
    Dates_List = Table.AddColumn(StarEnd_Dates_Format, "Data", each {Number.From([StartDate])..Number.From([EndDate])}),
    Dates_Expand = Table.ExpandListColumn(Dates_List, "Data")
in
   Dates_List 

Good feedback. It sounds like you work with Power Query

Maybe the feedback would have a higher change of being seen by the right people in that forum.

Hi Teefo,

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

Currently, Power BI's Advanced Editor in Power Query does not support rich text editing features such as Find & Replace, syntax highlighting, or the ability to leave comments or visual formatting like highlighting or emojis. It is a simple code editor for editing M language and lacks the advanced editing capabilities commonly found in modern code editors.​

Suggestions and Workarounds

• Many community users echo your feedback and would like features like global Find & Replace, multi-select editing, highlighting, commenting, and richer formatting support.​

• Currently, the best option is to copy your M code to a dedicated code editor such as VS Code (which supports these features), make your edits, and paste the code back into Power BI.​

• Feature requests for a more advanced editor with text manipulation and formatting options are already popular in the Power BI community.​

for now, use an external code editor for heavy text editing and continue upvoting or providing feedback so Microsoft can consider adding these capabilities to the Advanced Editor in Power Power BI.

Hi Teefo,

Thank you ThomasWeppler MFelix for your response to the query.

Has your issue been resolved?
If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone. 

Thank you for your understanding!