Merge Tables cannot see table

[m1ngle]

Hey all - apologies if this is super obvious. I created a table called 'instructional_support' using DAX. I would like to merge this table with another table, 'instructional_metrics' generated through a query connected to an Azure Database. Is this possible? When I go to Transform data > merge queries, instructional_sort isn't there. It's not in the list. The table 'instructional_metrics' created through a query is visible. Is there anything I can do to merge these two tables? Ultimate goal is to sort a column in 'instructional_metrics' and this way came up in google searches.

[vicky_ · Accepted solution]

PowerQuery doesn't have access to the tables / columns you create in DAX. Consider if you really need to merge the tables, or whether you can just use a relationship to handle your calculations.

If you really need to merge them, then you can either use DAX functions such as CROSSJOIN, ADDCOLUMNS or SUMMARIZE to create a new table.