Expressions that yield variant data-type cannot be used to define calculated columns.

[Anonymous]

i get an error while having the below caluclated column

IF('Scores'[Current/Last]="-","-",IF('Scores'[Question Scores]<>0, IF(_score='Scores'[Question Scores],0,_score) ))

Do anyone know how to solve the error? 

[Greg_Deckler]

@Anonymous Try below. You either need to return all text or all numbers, not text and numbers.

IF('Scores'[Current/Last]="-","-",IF('Scores'[Question Scores]<>0, IF(_score='Scores'[Question Scores],"0",_score & "") ))

[Anonymous]

But if i return it into calculated column, it will return error as well. Or i need to use the format function in DAX? if yes, how should it be like?

[Greg_Deckler]

@Anonymous The measure I posted returns all text. Alternatively, you could write the formula this way to return either BLANK or numbers and it would work as well:

IF('Scores'[Current/Last]="-",BLANK(),IF('Scores'[Question Scores]<>0, IF(_score='Scores'[Question Scores],0,_score) ))

[Anonymous]

But exactly want "-", as i need to use "-" in the report view if it is no data instead of just blank. Any idea for that?

[Greg_Deckler]

@Anonymous Use the first formula then. Bottom line, you either need to return text or return numbers. You *might* be able to use the second form for a number and use a Custom Format String to display your blank values as "-". Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn