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 guys, how are you?
I've been trying to merge two tables, but both of them have two keys. In SQL it's easy to do that with select * from... but it seems that Power BI can't.
This are my tables: A is a product sales (with date of sale), and B is service sales (with date of service). I want to merge these two tables since product service retentions depends on what product were sold. I attached a image for reference:
As you see, I want to know what sales and service were done monthly, by customer.
Please, your help will be greatly appreciated.
Regards,
Alexis
Solved! Go to Solution.
As per your requirement,
Join the above table with TableA and TableB
As per your requirement,
Join the above table with TableA and TableB
Many-Many relationship is not supported in power BI. Hence you cannot merge Table A and table B. Instead you can try the alternate by having a master table for Vendor(i guess you are using the Vendor field to merge the two tables in SQL)
1) Create a query in Power BI to get the distinct Vendor from Table A and table B and the name resulting table as VendorMaster
2)Create relationship within PowerBI VendorMAster->TableA and VendorMaster->TableB
Then you can create a measure to get the required result
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |