cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 
 

 

2 REPLIES 2
Anonymous
Not applicable

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
Super User
Super User

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!