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

[Anonymous]

 I'm having a table where I'm trying to categrorise all the date before 1/1/2000 as bad and after 1/1/2000 the actual date from each corresponding row.
This is the DAx I wrote:

Draft = IF ( 'TableA'[A] >=153864, "bad" , 'Fact'[A). I also tried this

Draft = IF( CONVERT('TableA'[A],STRING)>="153864","bad",'TableA'[A])

and this is the error I Get  "Expressions that yield variant data-type cannot be used to define calculated columns."

I tried several versions of if but I still get the same error. Thank You for helping me with this.

[Anonymous]

@Anonymous  Thanks a lot that's the solution

[Anonymous · Accepted solution]

I think you need to use the CONVERT function a second time, assuming [A] is an integer.

Try: Draft = IF( CONVERT('TableA'[A],STRING)>="153864","bad",CONVERT(TableA'[A], STRING))