Creating unique template work

[divumj]

Hi All

I am in process of creating multiple template for comparing two set of data. I need to repeat few steps again and again in all template.

Is there any way I can create a dummy template which can work on every automation, I can add the operation on excel and power query read those and perform including column names.

[dk_dk · Accepted solution]

Hi @divumj 

Have a look at creating custom Power Query functions and see if that is something suitable for your use-case.

https://learn.microsoft.com/en-us/power-query/custom-function

[divumj]

Let me go through and check but it seems workable for me

[Omid_Motamedise · Accepted solution]

Yes, you can use custome function .

for examle 

(x,y)=> List.Difference(x,y)

[dk_dk · Accepted solution]

Hi @divumj 

Have a look at creating custom Power Query functions and see if that is something suitable for your use-case.

https://learn.microsoft.com/en-us/power-query/custom-function