Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Currency Conversation

I have a fact table which has Invoice amount,currency( having mutiple currencies),invoice number also have another table currency conversion which has Starting currency, distination currency, exchang...

mwegener
6 years ago
Hi Anonymous ,

was your problem solved?

Icon for Super User rank

Super User

6 years ago

Hi Anonymous ,

CAn you explain your query using some screenshots from sample data and Power BI?

This is not helping much here.

Thanks,

Pragati

Anonymous

Not applicable

6 years ago

Sample Data attached. I need the final report of invoice amount in $ value.

Anonymous
Not applicable
6 years ago
Hi Anonymous ,

You can have a look at these Videos.

https://www.youtube.com/watch?v=Q4hF4CwJsFE
https://www.youtube.com/watch?v=_ubNovnNx5k
https://www.youtube.com/watch?v=4dosxfNxR6M

https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
v-diye-msft
Community Support
6 years ago
Hi Anonymous

Would you like to get the invoice amount based on the JPY? and exchange rate is limited in the date? there are no range dates for any specific pair of starting currency to destination currency, that's unable to determine the exchange rate in your invoice date.

You might refer to the similar post below for some pointers, if you'd like to get the exact results, kindly elaborate more details.

https://community.powerbi.com/t5/Desktop/Issue-with-calculating-revenue-because-of-exchange-rates/m-p/1212140#M540342

Related content