Forum Discussion

Teefo's avatar
Teefo
New Member
9 months ago

Add Text edit capacities to the Advance Editor

Hi, we need to handle the Advance Editor Faster, f.e. when copying the series of query processes and there is a column header difference I should be able to replace all and enjoy life. I also want to...
General Comment
MFelix's avatar
MFelix
Super User
9 months ago

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