Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is my submission to EDNA Powerbi 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.
I have also attached the working PBIX file. Please let me know your view, feedbacks and suggestions in the comments below.
If you liked my DASHBOARD please give it a thumbs up and share it. #CURRENCY_CONVERSION_DASHBOARD.
eyJrIjoiNWQ2YjY2NzUtZjRmNi00MTdlLTg1MGMtNzFhNzQ3YzY1MTFkIiwidCI6IjQ5MzkwMzQ4LTk2ZGMtNDZhZC05YTYyLWMxMDQzMDIwZmQ2MyJ9&pageName=ReportSectionfabb495778030d2a31e2
This is great @Ali_India ! 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 :).
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/