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.
I have 2 reports (fact tables) coming from 2 different softwares. Hardware sales and Service sales. The common value is Customer ID. I am not able to add relations between the 2 tables. Do I need a bridge table ? What do you suggest ?
Solved! Go to Solution.
You want a customer table that has all of the customers from both of the sales tables. Then you can link that to your sales tables and do reporting on both types of sales by customer. You will also want a calendar table so you can do date reporting.
This might be a good course to start with and it is free.
https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/
You want a customer table that has all of the customers from both of the sales tables. Then you can link that to your sales tables and do reporting on both types of sales by customer. You will also want a calendar table so you can do date reporting.
This might be a good course to start with and it is free.
https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/
Thank you very much.
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |