Forum Discussion

m1ngle's avatar
m1ngle
Frequent Visitor
2 years ago
Solved

Merge Tables cannot see table

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 throug...
  • vicky_'s avatar
    2 years ago

    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.