Forum Discussion

julrua's avatar
julrua
Frequent Visitor
5 years ago
Solved

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 0...
Need Help
  • julrua's avatar
    julrua
    5 years ago

    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's avatar
    V-lianl-msft
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
julrua
Frequent Visitor
5 years ago

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