Get avergae of a Text

[Anonymous]

Hi!

Is it possible tyo get an avergae of a text column, I am not looking to get the count average but the text itself.

For example if I have a column :

Col

A

A

C

B

A

C

B

A

I need to get an average of the Alphabets where each alphabet represents the revesion version, like in the above example should "A"

Thanks

[Anonymous]

If it's a revision version then convert these letters to their corresponding numbers, take an average of them and then round it up or down and again convert to the corresponding letter.

Best
D

[Greg_Deckler]

So explain why that is the average, becaues it is the most frequently occurring? Maybe MODE? https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Single-Column/m-p/359150#M101

Take the UNICODE's of the characters, average that and return the INT of the average using UNICHAR?

Create a "lookup" table where you assign a value to each, 1, 2, 3 take the average of the numbers, translate back

I don't know, that is a weird request. 

[Anonymous]

Hi,

Thanks, That is exactly waht I was doing but , I am unable tyo translate it back, I get the decimal number which I round it up , but I need to show it on a card as a KPI after translated back tyo the Albhabet.