CURRENCY CONVERSION DASHBOARD

Question

This is my submission to EDNA Powerbi Challenge 9.
&nbsp;
The main challenge is to create a conversion model with 3 reporting currencies. I used Google sheets to get the daily fx rates with&nbsp;&nbsp;=GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD), DATE(YYYY,MM,DD).
&nbsp;
This dashboard displays key metrics like Sales, Cost and Profit of a fictional recyle company. My main goal is to find loss making attributes in the dataset.
&nbsp;
Main requirement is to produce a report from the data to give the user the ability to select a currency and see the associated sales and cost.&nbsp;I also used tooltips to provide additional insight.&nbsp;Hardest part is to calculate the profitability, Sales &amp; Cost as we have multiple currencies involved in the business.
&nbsp;
I have also attached the working PBIX file.&nbsp;Please let me know your view, feedbacks and suggestions in the comments below.
&nbsp;
If you liked my DASHBOARD please give it a thumbs up and share it. #CURRENCY_CONVERSION_DASHBOARD.
eyJrIjoiNWQ2YjY2NzUtZjRmNi00MTdlLTg1MGMtNzFhNzQ3YzY1MTFkIiwidCI6IjQ5MzkwMzQ4LTk2ZGMtNDZhZC05YTYyLWMxMDQzMDIwZmQ2MyJ9&amp;pageName=ReportSectionfabb495778030d2a31e2

datazoe · Answer

This is great&nbsp;Ali_India&nbsp;! I didn't know you could get the exchange rates so easily in google sheets, I'll admit my method was much more brute force :).&nbsp;