Forum Discussion
Helper Inew query from table
Helper IHi Phil_Seamark, correct.
However, if I need to create queries using this generated table, would that be possible?
This generated table was done as: New Table = GENERATE('Table01','Table02')
Microsoft Employee
Do you mean new queries to your source system? Do you want to somehow use the rows in this table to generate a loop of queries? Or something else?
- henrique0galli
Hi Phil_Seamark,
so I want to be able to Merge queries As New (based on the queries I already have), but also being able to merge this new table generated.
How can I manipulate this generated table into the existing queries and merging them?
- Phil_Seamark
oh, you can't "merge as new" as this table has been generated downstream of Power Query.
But you can create new DAX calculated tables using the GENERATE function with filters.
- henrique0galli
Hi Phil_Seamark,
how could I use the function with filters?
I now know how to create new tables using GENERATE, however how should I agregate the filters in the function?
Rgs,