Calculate Exchange Rates Using M Code

Hi Anonymous ,

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.