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

 

How write the Dax funtion for avove condition?

 

 

 

 

 

Need Help

3 Replies

  • Thejeswar's avatar
    Thejeswar
    Super 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

     

    • Thejeswar's avatar
      Thejeswar
      Super User
      3 years ago

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