Files

20 lines
345 B
Dax

DEFINE
FUNCTION Switch_Unit_Value = (unit , O_Value) =>
SWITCH(
unit,
"RMB", O_Value,
"K RMB", O_Value / 1000,
"M RMB", O_Value / 1000000,
"USD", DIVIDE(
O_Value,
[ExchangeRate]
),
"K USD", DIVIDE(
O_Value,
[ExchangeRate]
) / 1000,
"M USD", DIVIDE(
O_Value,
[ExchangeRate]
) / 1000000
)