Forum Discussion
m1ngle
2 years agoFrequent Visitor
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...
- 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.
vicky_
2 years agoSuper User
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.