Forum Discussion

MarkPalmberg's avatar
MarkPalmberg
Icon for Kudo Commander rankKudo Commander
7 years ago

Table visual trouble

I have three queries in my data model. One contains unique IDs for all the customers in my database. The second contains address information for my customers (multiple addresses per customer), and th...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi MarkPalmberg ,

 

There are several solutions you can considerate:

 

1.You may try using the CROSSJOIN function to create a calculated table like DAX below.

 

Table = CROSSJOIN(Table1,Table2,Table3)

 

2.You may use Merge Queries (Table.NestedJoin) in Query Editor.

 

3.You may use the merge feature in Query Editor.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.