Different currency format in one column

[julrua]

Hello everyone, 

I was wondering if I can have different currency format in one column. 

For the moment, I have the following 2 columns 

Currency         Actual amount 

SGD                13 000

EUR                14 000

EUR                170 000

Would it be possible to have? 

Currency          Actual amount 

SGD                  13 000 SGD 

EUR                   14 000 € 

EUR                   170 000 € 

Thank you in advance for you help!

Julia  

[julrua · Accepted solution]

Thank you for your quick response.

So if I understand correctly I have to

1 - Create a duplicate of my Actual Amount column to transform into text

2 - Create a custom column with the Text.Combine function

Am I right?

Thank you

[V-lianl-msft · Accepted solution]

Hi @julrua,

Please refer:

combine = SWITCH(TRUE(),
            'Table (2)'[Currency]="EUR",'Table (2)'[amount ]&" €",
            'Table (2)'[Currency]="SGD",'Table (2)'[amount ]&" SGD")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@julrua , You can append but it will become text column.  That is what I think. I doubt you have option as of now to append currency symbol conditionally

[julrua · Accepted solution]

Thank you for your quick response.

So if I understand correctly I have to

1 - Create a duplicate of my Actual Amount column to transform into text

2 - Create a custom column with the Text.Combine function

Am I right?

Thank you