This challenge as all about converting the source currencies for sales, purchase, and hauling that can be in either dollars, pounds, or euros into a one currency, again, with the users choice on which of the three they are all converted to. In addition, the formatted values are also shown with the correct formatting throughout the report.
I hvae a full write up on it here: https://forum.enterprisedna.co/t/power-bi-challenge-9-currency-conversion-and-more-from-zoe/12106/2
Be sure to check out the tooltips!
eyJrIjoiZTlkOTdlYTYtYmQ4Yy00M2YxLTgzY2QtMTNkNTAxMjhlODA3IiwidCI6IjkyOWVlMzI0LTk3YzQtNDk1YS04MjM5LTZhZDg3NDk0MGVlYyIsImMiOjN9
Respectfully,
DataZoe
See my reports and blog at https://www.datazoepowerbi.com/