Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@mtrussardi , you can use min/max , but aggregation is must
@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...
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |