Greg on 01 Apr 2017 02:51:32
Similar to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18476596-custom-reusable-dax-function
I think it would be awesome if we could add our own functions/favorites to the Power Query Editor Interface. What I mean is that for example, in the built in Date & Time functions on the Ribbon, there is nothing remotely like the following:
= Table.AddColumn(#"Source", "Period", each Text.From(Date.Year([DATECOLUMNNAMETOCONVERT])) & "-" & Text.PadStart(Text.From(Date.Month([DATECOLUMNNAMETOCONVERT])),2,"0"))
Imagine being able to save this function and have it as a button (preferably under the Date button dropdown) so I could quickly add it just as if it was a built in command. If not integrated with the built in commands, then maybe just customizable like the Ribbon in Excel itself with Macros.
Currently I have to keep all of these types of commonly used expressions saved in a text editor and copy paste as needed.