Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
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.
@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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |