Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |