CODEWITHSUNDEEP
excelpowerquery
Andrew
Andrew

Reputation: 105

Excel custom function from Power Query

in VBA we can create a function that we can then call directly and with arguments from excel sheet . I'm wondering if there is same possibility with power query instead of VBA. Note, I know you can create user defined functions within power query, but this is not what I'm looking for.

Upvotes: 1

Views: 425

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40244

You can't use a Power Query function outside of the query editor, at least not directly in an Excel formula. You can set a table of inputs and run it through a query to get a table of outputs but that requires refreshing the query every time you change the inputs.

Upvotes: 1

Related Questions