The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi There! I am trying to get a quick sales table worked up but I can't figure out the Dax, and I'm hoping someone can help!
We have two tables related to the sale of products:
I am trying to output a matrix table (TABLE 3?) which contains values from TABLE 1 and TABLE 2 multiplied together. The overall work is pretty simple, I just cannot find anything to match the two tables together due to the duplicates in both tables.
Here's an image showing this in action:
I've color coded the rows to show how they connect to each other.
It's such a simple problem, but I cannot figure it out, can anyone help? Here's a copy of the table data in a PBI file: https://drive.google.com/file/d/172S26uzVDH79d_CEzCs5as_xZCWfo9n0/view?usp=share_link