Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Get avergae of a Text

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

3 REPLIES 3
avatar user
Anonymous
Not applicable

Syndicated - Outbound 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
Super User
Super User

Syndicated - Outbound

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. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)