cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ANM_97
Helper III
Helper III

Dividing the value by currency

Hello!

 

I have the following problem:

PRICECURRENCY
500EUR
200USD

 

And these are the values ​​of the currencies in the daily record table:

DATACURRENCY_CODEVALUE
29.05.2020EUR4.8426
29.05.2020USD4.3517

 

How can I build a measure that divides the price by the value of the currency?

The results should be:

PRICECURRENCYPRICE IN RON
500EUR103.25
200USD45.96

 

Thank you~

 

1 ACCEPTED SOLUTION
1 REPLY 1

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors