Forum Discussion

durlav1993's avatar
durlav1993
Frequent Visitor
3 years ago

power bi

HI team, i have two column ,both value "Yes" and "No" i need to find out if both "yes" means completed, If both "Yes","No" means 'Partially", and if both "no" means Not completed, If both data Blank...
Need Help
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
3 years ago

Hi durlav1993 ,

You can create a Calculated Column using the below DAX to achieve this

CalcColumn = IF('Table'[Column1]= "" && 'Table'[Column2]="", "Not Updated", IF('Table'[Column1] = "Yes" && 'Table'[Column2] = "Yes", "Completed", IF('Table'[Column1] = "No" && 'Table'[Column2] = "No", "Not Completed", "Partially")))

Screenshot given below for reference