Forum Discussion

jinweitan's avatar
jinweitan
Frequent Visitor
5 years ago
Solved

Calculate Average in a column including text string

Hi all,

 

I have a table in my Power BI Report

 

NameScore
John10
Sue20
Kelly-

 

and what I want to make it into is as following:

NameScore
John10
Sue20
Kelly-
Average15

 

I've tried using quick measure, but it says that it is unable to calculate as the column contains type string.

 

Hope to get some advice here.

 

Many thanks.

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    jinweitan , Create a new column like this and use that

    new Score =if([Score] ="-",blank(),[Score]) //Change data type as whole number

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    jinweitan , Create a new column like this and use that

    new Score =if([Score] ="-",blank(),[Score]) //Change data type as whole number