Forum Discussion
Currency Format
Hi everyone, I wrote this code as a measure:
Moneda Seleccionada =
VAR CAMBIO = SELECTEDVALUE(Hoja4[SIGLAS])
RETURN
IF(CAMBIO="USD",
FORMAT([TOTAL USD],"$ #.##"),
IF(CAMBIO="PE",
"S/" & " " & FORMAT ( [TOTAL SOLES], "#.##" ),
FORMAT([TOTAL REALES],"R$ #,##")))
FORMAT([TOTAL REALES],"R$ #,##")))
And I am trying yo see this information in a matrix but I cant get them line up to the right. As it is shown the total is on the left.
