Forum Discussion
Solved
Calculate Average in a column including text string
Hi all, I have a table in my Power BI Report Name Score John 10 Sue 20 Kelly - and what I want to make it into is as following: Name Score John 10 Sue 20 ...
jinweitan , Create a new column like this and use that
new Score =if([Score] ="-",blank(),[Score]) //Change data type as whole number
amitchandak
Super User
Super Userjinweitan , Create a new column like this and use that
new Score =if([Score] ="-",blank(),[Score]) //Change data type as whole number