skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Retail
    • For analysts
    • For IT
    • For developers
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
      • Overview
      • Guided learning
      • Documentation
      • Webinars
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Galleries
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • MBAS Gallery
    • MBAS Gallery 2020
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • CURRENCY CONVERSION DASHBOARD

    CURRENCY CONVERSION DASHBOARD

    11-16-2020 21:53 PM - last edited 11-16-2020 22:24 PM

    Ali_India
    Advocate II
    667 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Ali_India
    Ali_India Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    CURRENCY CONVERSION DASHBOARD

    ‎11-16-2020 09:53 PM

    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

    EDNA Challenge 9_Mohammed Ali.pbix
    Labels:
    • Labels:
    • Business
    Message 1 of 2
    667 Views
    3
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    DataZoe
    Super User II DataZoe
    Super User II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-17-2020 10:06 AM

    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,
    DataZoe

    See how I formatted the DAX in my blog post

    See my reports and blog at https://www.datazoepowerbi.com/

    Message 2 of 2
    500 Views
    1
    Reply
    Preview Exit Preview

    never-displayed

    You must be signed in to add attachments

    never-displayed

    Additional options
    You do not have permission to remove this product association.
     

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    • © 2021 Microsoft
    • Follow Power BI
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks