Power BI Challenge 9 - Currency Conversion and More from Mohammed

Here’s Mohammed’s entry for Power BI Challenge 9. @Mohammed_ali, feel free to add other details of your work.

image

Here’s how Mohammed described it:

This is my submission to EDNA Power BI Challenge 9.

The main challenge is to create a conversion model with 3 reporting currencies. I used Google sheets to get the daily fx rates with =GOOGLEFINANCE("Currency:USDGBP", "price", DATE(YYYY,MM,DD), DATE(YYYY,MM,DD).

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.

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. I also used tooltips to provide additional insight. Hardest part is to calculate the profitability, Sales & Cost as we have multiple currencies involved in the business.

Please let me know your view, feedbacks and suggestions in the comments below.

This post is part of the Enterprise DNA platform improvements, through the Data Challenge our members can now share how they built their dashboard and what their inspiration is in building it. We hope all members can utilize it efficiently.