Forum Discussion
Creating a new table with missing data and calculation over different tables
Hey Sam,
I've attached a sample pbix to solve your problem.
The key thing I did was to create a customer table that has a relationship with both tables. (You can right-click the Customers table and go to Edit query to see how I created that table directly from your data.)
If you don't already know the terms dimension table and fact table, this wonderful course from SQLBI will be a great foundational learning for you. The bad news is your problem was indeed quite simple. However, the great news is your problem was very simple; you can have pretty easily learn the tools to solve this if you want!
Please feel free to ask followup questions and I will be happy to answer them. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Hey Sam,
I've attached a sample pbix to solve your problem.
The key thing I did was to create a customer table that has a relationship with both tables. (You can right-click the Customers table and go to Edit query to see how I created that table directly from your data.)
If you don't already know the terms dimension table and fact table, this wonderful course from SQLBI will be a great foundational learning for you. The bad news is your problem was indeed quite simple. However, the great news is your problem was very simple; you can have pretty easily learn the tools to solve this if you want!
Please feel free to ask followup questions and I will be happy to answer them. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
