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 tables. Project table and Currency table. Both are joined by the column "CurrencyISOCode" which is present in both the tables. My requirement is to divide the Project.Amount by Currency.ConversionRate based on the "CurrencyISOCodes". Please suggest an expression for a calculated column for this.
So, is that a 1:1 relationship or? What does your Currency table look like assuming what you posted is the Project table?
Hi Greg,
Thanks for your reply. Here is my Currency Table. It is a 1:M relationship as CurrencyISOCode is present only once in "Currency Table" but is present numerous times in "Project" table.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |