Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Recalculations currency Table

  • 1.  Recalculations currency Table

    Posted Nov 15, 2019 10:04 AM

    Hello ,

    Need help to provide some examples , where I can see how to recalculated dynamically table with different currency.

     

    For example.

    1. Table contains multi currencies along with numeric columns with actual sales and budgets.
    2. We need to perform recalculations all entries in display all in EUR or USD currencies via action button or some type of selection.

         


    Laurie Yekelchik

     

    Academy - Online Interactive Learning from Experts


  • 2.  RE: Recalculations currency Table

    Top Contributor
    Posted Nov 15, 2019 02:47 PM
    Hi Laurie !

    You need to have a currency conversion table which includes currency conversion rates.

    Now you have 1 base measure which calculate sales in USD, from this base measure you derive other measure to show EUR value using currency conversion table.

    Using a slicer filter you can write expression to show selected currency based on slicer selection using IF statement.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Recalculations currency Table

    Top Contributor
    Posted Nov 15, 2019 03:19 PM
      |   view attached
    Hi Laurie !

    Please find attached file where i have used currency table & following DAX to calculate Sales based on currency selection from slicer;

    Sales Currency = CALCULATE(Sales[Sales] * SUM(CurrencyRates[Units per USD]), FILTER(CurrencyRates, CurrencyRates[Currency code▲▼] = SELECTEDVALUE(CurrencyRates[Currency code▲▼])) )

    See Report page [Sales2]

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Attachment(s)

    pbix
    SalesAnalysis_11.pbix   1.14MB 1 version
    Academy - Online Interactive Learning from Experts


  • 4.  RE: Recalculations currency Table

    Posted Nov 18, 2019 10:02 AM
    ​Thank you Hasham very much for your support and details explanation!
    so much appreciated for all your support. I will be back to you, if some questions come up from my side.
    Have a great day.   


    ------------------------------
    Laurie Yekelchik
    IT Project
    860-8336434
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Recalculations currency Table

    Top Contributor
    Posted Nov 18, 2019 10:00 PM
    Hi !

    Glad it worked for you.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Academy - Online Interactive Learning from Experts