Adding unicode to a column

[Zepox]

Hello all,

I have a quick question about using unicode in power query.

I have customer names with an index for each of the names, now I would like to multiple the customer index with unicode (8204) to make each customer name unique while still showing the same name, much like this post does it in Dax https://www.sqlbi.com/articles/handling-customers-with-the-same-name-in-power-bi/. The reason I want to do this is because I would like to make a dynamic axis for which I need to pivot te data in power query.

However I can't seem to get any unicode into power query, is this at all possible?

[BA_Pete · Accepted solution]

Hi @Zepox ,

In Power Query, you can use the following functions, depending on which way you want to do the conversion:

Character.FromNumber()
Character.ToNumber()

Pete

[Zepox]

Makes sense, thank you!