Excel to Dax Calculation

[Anonymous]

Hi, 

I need to convert formula from Excel to Powerbi as a calculated column to return true/false as a output
Excel - =AND(Column1="YES",OR(Column2="Done",Column2="InProgress")) 

Dax calculated column ? Any help 

[amitchandak · Accepted solution]

@Anonymous , a new column

if(AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress")), true(), false() ) 

or

AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress"))