topic Re: if statement help in DAX Commands and Tips

if statement help

Anonymous — Fri, 21 Feb 2020 05:30:31 GMT

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

Re: if statement help

az38 — Fri, 21 Feb 2020 07:30:45 GMT

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

Re: if statement help

Anonymous — Sat, 22 Feb 2020 15:24:25 GMT

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