Skip to main content

Power BI

Needs Votes

Add "Invoke Custom Function" in the Transformation Ribbon in the Power Query editor

Vote (1) Share
Pär Adeen's profile image

Pär Adeen on 23 May 2021 17:12:39

The "Add Column" tab already have an "Invoke Custom Function", but the transformation tab are missing a "Invoke Custom Function".

The "Invoke Custom Function" in the transformation tab can work like the already existing "Invoke Function" we see whenever clicking on a function, but with also the previous applied step available (and pre-selected) as a table source.

The rational is to also support custom functions taking tables as arguments from the GUI. The workaround now is to either add an extra step (Inser step after) and modify as your custom function, or to edit the code using the advanced editor.