Convert multiple currencies to USD using multiple currency Fx Table with missing weekend/other dates

[Anonymous]

I have a table that has different currency values. I am trying to add a new measure that will convert just the total currency values to US $.  I will not be using a conversion table but will put the exchange rate into the dax formula for each differeny currecy. I need help in the creating of the DAX stament that will allow me to do this. Thanks

[jdbuchanan71 · Accepted solution]

Hello @Anonymous ,

You can do this with a SUMX and SWITCH against your data table.

SCRAP_COST USD =
SUMX (
    Table,
    Table[SCRAP_COST] *
        VAR RowCurrency = Table[CURRENCY]
        RETURN
            SWITCH (
                TRUE (),
                RowCurrency = "USD", 1,
                RowCurrency = "GBP", 1.26992,
                RowCurrency = "MXN", 0.5250859,
                1
            )
)