Change Currency Symbol at Power Query level

Hi qbarnes ,

Actually you can add currency symbol in power query but it will be a text column so that we cannot use it to calculate unless the column value has been calculated in advance then we convert it to a text column.

Power query code may like this:

Custom1 = Table.AddColumn(
        #"Changed Type",
        "Orignal",
        each if [Entity Location] = "Canada" or [Entity Location] = "USA" 
             then 
                "$ " &  Text.From([Original Bal]) 
                    else if [Entity Location] = "UK" 
                        then 
                            "£ " &  Text.From([Original Bal]) 
                                else null
    ),
    Custom2 = Table.AddColumn(
        Custom1,
        "Present",
        each if [Entity Location] = "Canada" or [Entity Location] = "USA" 
             then 
                "$ " &  Text.From([Present Bal]) 
                    else if [Entity Location] = "UK" 
                        then 
                            "£ " &  Text.From([Present Bal]) 
                                else null
    )

Attached my sample file that you can refer: currency symbol.pbix

Best Regards,
Yingjie Li

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