Forum Discussion
Multiply two columns from different table with condition
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.
4 Replies
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-Difference-Across/ba-p/934397#M451
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.
Any developments?
mtrussardi , you can use min/max , but aggregation is must
