Forum Discussion
Playing with 2 fact tables
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.
Super UserYou 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.