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.
I have two different tables. One is a table with Currency rates. The other is a table with my sales orders. I have a relationship built in both tables where the Currency_Month_Year matches on a many to 1 relationship from sales orders to currency. I'm trying to put in a calculation where it multiplies my Net amount with my Value (Value is my currency rate) to give me a value in USD.
I've tried using quick measures but it wants me to take count of value and I don't want to do that.
In essence, it should be (SalesTable[Net amount] x (FX rates[Value])
Therefore in row 1, 0; row 2 = 1266, etc.
Solved! Go to Solution.
Hi @Anonymous
Have you tried a calculated column in your SalesTable like this?
New Column = 'SalesTable'[Net Amount] * RELATED('FX Rates'[Value])
Hi @Anonymous,
If you want to get the desired value in calculated column, you could try this formula:
Column = 'SalesTable'[Net Amount] * RELATED('FX Rates'[Value])
If you want to do calculation via measure, you could try:
Measure = MAX('SalesTable'[Net amount])*MAX('FX rates'[Value])
Best regards,
Yuliana Gu
Hi @Anonymous
Have you tried a calculated column in your SalesTable like this?
New Column = 'SalesTable'[Net Amount] * RELATED('FX Rates'[Value])
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |