Forum Discussion
Different currency format in one column
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
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
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.
3 Replies
- amitchandak
Super User
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
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-msftCommunity Support
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.
