Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
LOOKUPVALUE dont work in Direct Query Mode...
Hi @Fact,
What is your data source?
Regards,
Yuliana Gu
Hi @Fact,
Maybe you can achieve such a dataset via SQL Query when creating data source connection.
Best regards,
Yuliana Gu
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |