Setting up currency code with dynamic measures: how to add the currency code after numbers?

[Anonymous]

Dear All,

I have this measure for adding currency code in calculations, and as you can see the "currency code" is positioned before numbers. I would like to have the opposite: currency code after numbers.

In summary, instead of "RUB#1275239441.5" i would like "1275239441.5 RUB". How can i adapt my measure to achieve this goal?

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can try to change the position of the two parameters.

For example:

CONCATENATE(CONCATENATE([MTD TGS LC], " "), _ctype)

Best Regards,

Jay

[amitchandak]

@Anonymous , You can use isinscope or hasonevalue to switch the grand total measure or format

https://xxlbi.com/blog/new-dax-function-isinscope/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/