if statement help

[Anonymous]

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 

[Anonymous]

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

[az38]

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") ) ,""))