Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |