Forum Discussion
Creating New Dynamic Queries or Blank Queries from within an Existing Power Query Query
I am thinking I already know the answer to this, but does anyone know if it is possible to create a new query from an existing query? I.e. Does the language spec have a means of calling the UI equiva...
Hi,
This may be oversimplified, but you can reference a query in the same model by right clicking the original query and choosing "Reference Query" or in the new query type the name of the query you are referencing in the Source line.
let
Source = "Original Query Name"
Hope that helps!
~Kim
No, Power Query doesn't have eval() functions. What it does have though is each and _ - those allow you to iterate over arrays and contexts so you can create pretty elaborate logic all with a little lookup table (for example a list of active departments for which you want to do the ETL)
A lot of the Power Query functions accept custom functions as parameters - another very powerful concept that will help you.