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
confidentnwrong's avatar
confidentnwrong
Advocate I
3 years ago

You need a way to aggregate 'Opp Contact Role'[Days between].

One way of doing this is :

=
var W3 = MIN('Opp Contact Role'[Days between])
RETURN
IF(W3<=-91
,"Excluded"
 ,IF(W3>90
 ,"Excluded"
  ,IF(W3>1
  ,"Influenced" 
   ,IF(W3<=0
   ,"Sourced"
   ,"Influenced")
  )
 )
)

 

Depending on your data, MIN can be MAX, SUM, AVG,... 

If you're 100% sure that there will be exactly 1 value that will show up using [Days Between], then all of these will return the same one.