Thank you Damiano!

Hi Hendrick! Yes, in Power Query it is possible to nest custom function inside the other functions. A theoretical example is given below: (InputNumber as number)=> let Source = InputNumber+10, FXDivide = (InputNumber2 as number)=> let StartingNumber = InputNumber2, Divide = StartingNumber / 2 in Divide, DivideFirstStep = FXDivide(Source) in DivideFirstStep In this function, you can see that we have a nested function called FXDivide that is local to this function only so it cannot be invoked from other queries (this is not necessary, FXDivide could also be defined as another query of the function type). For example, if number 10 enters this function, it will first become 20 (the Source step), and after the function definition, it will be divided by 2 with the third step (DIvideFirstStep). In this way, you could make a custom function in which other functions are executed. Thank you for your input! We might add this topic as one of our next videos :)

@@ExceedLearning Wonderful, very neat! ^^ thank you for the detailed explanation. So with the food prep example each of those actions could be defined within the query, or be calling other ‘function queries’. I’ll have to try this for a query I used recently with 5 steps I repeated across a few columns. Now I’ll just make a function of those 5 steps, and apply that function to each column. Much simpler. Thank you ^^. Any videos on the best way to share code with other colleagues so it’s easy for them to use the same functions would be much appreciated as well :)