Change True/False data type to Passed/Failed

[Lyhis]

Hi

I'm running a report in Direct Query. 1 Table has values "True" or "False". Data type - "true/false". I need to change it to "Passed/failed". So far everything I've tried wants to force me to import mode which I don't want.

[Tahreem24]

@Lyhis , Try this:

Column  = IF(TableName[Type]="TRUE","PASSED",IF(TableName[Type]="FALSE","FAILED"))

[amitchandak · Accepted solution]

@Lyhis , in this case you should be able to create a new column in direct query

if([Col], "passed","failed")

or

if([col]= true(), "passed","failed")