Replacing Text in a column with a number

[jamieham]

I want to replace the letter in a column with a number but I'm not sure how to do it in power bi.

Any help would be appreciated.

Column.          Replace

A                         1

B                         2

C                         3

D                         4

E                         5

etc

[Ashish_Mathur]

Hi,

This calculated column formula will work

=UNICODE(Data[Text])-64

Hope this helps.

[mahoneypat]

You could do this in the query editor with a custom column with this formula

=List.PositionOf({"A".."Z"}, [LetterColumn])+1

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[DataInsights · Accepted solution]

Try this calculated column. Add the remaining arguments (C, D, etc.).

Letter =
SWITCH ( Table[Column],
"A", 1,
"B", 2
)

[DataInsights]

Revised column name:

Number =

SWITCH ( Table[Column],
"A", 1,
"B", 2
)