convert excel formula to power bi.

[Anonymous]

hello, 

this is excel formula - =IF(AND([@[QA Last Reviewed Date]]<>"",[@[QA Last Reviewed Date]]>DATE(2016,5,19)),1,0)

I am using this in power bi - =IF(AND[QA Last Reviewed Date]<>""[QA Last Reviewed Date]>DATE(2016,5,19),1,0)

but it is giving this error - DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Please give the formula which performs same function . 

thanks 

[amitchandak · Accepted solution]

@SushantSharma, try how

IF(AND( not(isblank([QA Last Reviewed Date])),[QA Last Reviewed Date]>DATE(2016,5,19)),1,0)