Making "Shipped Amount" and "Order Amount" Measures to make a Matrix Visual

[MichaelG1117]

I can't use calculated columns in order to multiply two columns "Order Quantity" and "Sales Price" initially to get the overall Order Amount. 

The Order Amount and Shipped Amount use different dates, and I need to get them both into a Matrix Visual 

 Initially I use SumX('table', 'table'[column1] * 'table' [column2] to get the Order Amount. But I need to specify the date somehow with regard to "Shipping Amount" in order to get the measure necessary to implement the second row into the Matrix. 

I hope I am explaining this right. Any help would be awesome. 

Thanks...

MG

[Fowmy · Accepted solution]

@MichaelG1117 

If you have created two relationships from date table to your fact table, this video should guide you to achieve the expected result:  

https://youtu.be/zZLH8Y1tO1g?si=4TEFOyH4ULO8kypy

[Fowmy · Accepted solution]

@MichaelG1117 

If you have created two relationships from date table to your fact table, this video should guide you to achieve the expected result:  

https://youtu.be/zZLH8Y1tO1g?si=4TEFOyH4ULO8kypy

[MichaelG1117]

Got it, thanks!

[Fowmy · Accepted solution]

@MichaelG1117 

If the provided soluton worked for you please accept it as a solution so it will be useful for others as well