Help with formula

[lcasey]

Hello,

Does anyone know how I would substitute a Measure called "Currency"  rather than use a column in the Transactions Table called CCURNCYID

Revalued Balance (USD) =
SUMX ( 
 ADDCOLUMNS (
        SUMMARIZE (
         Transactions,
         Transactions[CCURNCYID]
  ),
        "Revalued Partial", CALCULATE ( SUM ( Transactions[BalanceCalc] ) ) * [Exchange Rate]
 ),
 [Revalued Partial]
)

[Anonymous]

Hi @lcasey,

You can try to use below formula if it works on your side:

Revalued Balance (USD) =
SUMX ( 
 ADDCOLUMNS (
        SELECTCOLUMNS(
         Transactions,
         "Currency",
         [Currency] //your meaaure
  ),
        "Revalued Partial", CALCULATE ( SUM ( Transactions[BalanceCalc] ) ) * [Exchange Rate]
 ),
 [Revalued Partial]
)

If above is not help, can you share some sample data?

Regards,

Xiaoxin Sheng