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 a data table that contains a list of transactions. Each transaction has a date and the cost in local currency. There is also a column with the currency code. I then have a look up table that brings data in from a seperate source. This table has a date field, the currency code and the conversion rate on that date.
I want to be able to add a column in my data table that brings in the local currency to USD conversion rate on the date of the transaction so that i can standardize the costs.
Can this be done?
Solved! Go to Solution.
Hi,
You should be able to use the LOOKUPVALUE() function. To get more help, share the download link of your PBI file and show the expected result there.
Hi,
You should be able to use the LOOKUPVALUE() function. To get more help, share the download link of your PBI file and show the expected result there.
@Johnweet , You can create table like this in you fact table
maxx(filter(Curr, Curr[Curr_code] = fact[Curr_code] && Fact[Date] = curr[Curr_date]) , curr[Rate])
you can multiple rate by amount and get the other currency value
I can't get that to work. My data table is called "All_ads". My Currency table is called "USDBase_Bloomberg". This is the formula i have.
Hi @Johnweet ,
Are you creating a measure? Please try this.
Conversion rate: =
MAXX (
FILTER (
USDBase_Bloomberg,
USDBase_Bloomberg[Currency] =MAX( All_ads[Currency_local])
&& MAX(All_ads[Date]) = USDBase_Bloomberg[Date]
),
USDBase_Bloomberg[Foreign_to_USD]
)
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
User | Count |
---|---|
117 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |