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 23 days ago

    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

     

    Conference-PBI_200x200


  • 2.  RE: Recalculations currency Table

    Top Contributor
    Posted 23 days ago
    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
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Recalculations currency Table

    Top Contributor
    Posted 23 days ago
      |   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
    Conference-PBI_200x200


  • 4.  RE: Recalculations currency Table

    Posted 20 days ago
    ​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
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Recalculations currency Table

    Top Contributor
    Posted 19 days ago
    Hi !

    Glad it worked for you.

    Regards,

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

    Conference-PBI_200x200