Multiply two columns from different table with condition

[mtrussardi]

Hello everyone!

I have one column titled ('Unit Cost') from the table named ('Raw Materials') and another column titled ('Rate') from the table ('Exchange Rates'). I would need to mulitply the column 'Unit Cost' times the column 'Rate' when the date is the same for the two tables. How could I do this?

Thanks in advance for your time.

Please, let me know.

[amitchandak]

@mtrussardi , you can use min/max , but aggregation is must

[amitchandak]

@mtrussardi , Create a common date table and then create a measure like

sumx(values(Date[date]), Sum(Table1[Unit Cost]) * sum(Table2[Rate]))

you can use min/max, average in place of sum

refer the concept here: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Differ...

[mtrussardi]

@amitchandak 

Thank you for your reply.

I tried the measure but the problem is that I don't want to calculate the sum. I just need to calculate the value of 'Unit Cost' times the "Rate' for each row when the date is the same.