Forum Discussion

giroldoale's avatar
giroldoale
Icon for Helper I rankHelper I
5 years ago
Solved

Why If Else Doesn't work?

Hi, I am not able to get rid off this issue. I have a column containings 0,1,2 and i need to construct another column giving the text "Completed" once the value is 2 and "NotCompleted"otherwise. A...
Need Help
  • giroldoale's avatar
    giroldoale
    5 years ago

    NEWS..

    I've try to simply close and reopen the report and now it's works! 

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

giroldoale  - Can you tell me what is the data type of TestopCompIDDynamic column (Sorry for wrongly typing this column name) ? If it is Text so just update your DAX like below:

Column = IF(Table[TestopCompIDDynamic] = "2","Completed","Not Completed")

 

  • giroldoale's avatar
    giroldoale
    Icon for Helper I rankHelper I
    5 years ago

    Hi, It's a "Whole Number"