The use of multiple tables without relationships

[Fact]

Hi, community. I have the following problem: there are 3 tables, to which connection is performed through a Direct Query. They have no related fields. How can I get a value from one table to another table? Or how can I create a new table based on three old ones. A specific example - how do I get the price for a particular company in the payments table?

shipments		payments		sales
date		date		date
company		company		company
shipped_weight		amount_money		price
				amount_money

Thanks in advance.

[v-yulgu-msft]

Hi @Fact,

Why don't you create relationships between tables? As I noticed there existing common fields in all three tables. Alternatively, if you don't want to create relationships, you can use LOOKUPVALUE to get a value from one table to another table.

Best regards,

Yuliana Gu

[Fact]

LOOKUPVALUE dont work in Direct Query Mode...

[v-yulgu-msft]

Hi @Fact,

What is your data source?

Regards,

Yuliana Gu

[Fact]

SQL Database

[v-yulgu-msft]

Hi @Fact,

Maybe you can achieve such a dataset via SQL Query when creating data source connection.

Best regards,

Yuliana Gu