Forum Discussion

PowerBI-Curious's avatar
PowerBI-Curious
Icon for Helper I rankHelper I
9 years ago
Solved

IF Rule - 3 conditions

Hi All

 

I am having trouble getting an IF rule of mine to work what I need to occur is the below: 

 

What I need to occur is: 

 

If 'User Target List'[CC Verification Actual Apr 2017]>='User Target List'[CC Verification Target Apr 2017], "Yes"

If 'User Target List'[CC Verification Actual Apr 2017] between 'User Target List'[CC Verification Target Apr 2017], "No"

If  'User Target List'[CC Verification Target Apr 2017] less than 0.5 "Not Applicable

 

I obviously keep getting it wrong as I get lots of errors.

 

Appreciate any help, sample data below.

https://1drv.ms/x/s!ArM9L8ohYGT4gQhszs0ssIc8haUT

 

PowerBI-Curious

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi

     

      Please use the below expression.

     

      replace Table1 with your table name, A with [CC Verification Actual Apr 2017] and B with [CC Verification Target Apr 2017].

     

    Name = IF(Table1[A]>Table1[B],"Yes",IF((Table1[A] > 0.5 && Table1[A] < Table1[B]),"No","Not Applicable"))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi

     

      Please use the below expression.

     

      replace Table1 with your table name, A with [CC Verification Actual Apr 2017] and B with [CC Verification Target Apr 2017].

     

    Name = IF(Table1[A]>Table1[B],"Yes",IF((Table1[A] > 0.5 && Table1[A] < Table1[B]),"No","Not Applicable"))