Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |