Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |