Forum Discussion
Excel to Dax Calculation
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
Anonymous , a new column
if(AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress")), true(), false() )
or
AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress"))
1 Reply
- amitchandak
Super User
Anonymous , a new column
if(AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress")), true(), false() )
or
AND([Column1]="YES",OR([Column2]="Done",[Column2] ="InProgress"))