Forum Discussion

sleekpeek's avatar
sleekpeek
Regular Visitor
3 years ago

Formula Help Please

I have this formula in excel, i'd like to create the same in PBI.   =IF(W3<=-91,"Excluded",IF(W3>90,"Excluded",IF(W3>1,"Influenced",IF(W3<=0,"Sourced","Influenced")))   W3 in PBI would be: 'Opp C...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this
create a new column

 

Column = 
VAR _t1 ='Opp Contact Role'[Days between]
RETURN
SWITCH( TRUE(),
       _t1<=-91,"Excluded",
       _t1>90,"Excluded",
       _t1>1,"Influenced",
       _t1<=0,"Sourced","Influenced")