power bi

[durlav1993]

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 means "Not Updated"

How write the Dax funtion for avove condition?

[durlav1993]

Thank you so much @Thejeswar 

[Thejeswar]

@durlav1993 , If that solved your ask, Accept the Post as Solution, so that this thread will be closed and available for others.

[Thejeswar]

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