Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

if statement help

Hi 

I am trying to use the below formula but it is not working 

Projects Status = if(Tasks[TaskName]=RELATED(TaskBaselines[ProjectName]),IF(Tasks[Progress]=100,"Completed",IF(Tasks[Progress]=0,"NOT Started","In Progress"),""))
 
I want to select specific row then start a new function on that
can anyone help me 
 

 

if statement
Need Help

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    Ive got no idea how you statement works, but I see an error -missed closed parenthesys ")" after "In progress"

     

    if(Tasks[TaskName]=RELATED(TaskBaselines[ProjectName]),IF(Tasks[Progress]=100,"Completed",IF(Tasks[Progress]=0,"NOT Started","In Progress") ) ,""))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    If you start formatting your DAX correctly, then you will not have to ponder over what's wrong with your formula. Please use the following site to format DAX: https://www.daxformatter.com/

    Bset
    D