Calculate Exchange Rates Using M Code

[tksnota]

Hi,

I need help to show the Debit or Credit Amounts with their correct exchange rates and not calculate if the value is zero.

I'm using only one table namely gbkmut with different fields as shown.

Thanks...tksnota... 

[Anonymous · Accepted solution]

Hi @tksnota ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

I have tried to replicate the scenario locally using sample data , which may help you obtain the Debit or Credit amounts with their correct exchange rates. Here are some suggested steps that might assist you:

1.After loading data into PowerBI, go to power query editor.
2.Add new Custom Column and name it as Debit_Exchange_Rate and enter the following code and click OK.
         each if [Debit] <> 0 then [Debit] * [Current_Exchange_Rate] else null

3.Again, add new custom column and name it as Credit_Exchange_Rate and enter the following code and click OK.
        each if [Credit] <> 0 then [Credit] * [Current_Exchange_Rate] else null

4.Click Close and Apply to get the updated changes.

Providing you the sample output for your reference.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[Greg_Deckler]

@tksnota So multiply Current_Exchange_Rate by Amount_DC ?