Forum Discussion

95Bigbluetoy's avatar
95Bigbluetoy
Helper I
6 years ago
Solved

IF Statement help with multiple variables

I have a data set that includes columns for employee names and job titles. I have created an IF statement so that if a job title equals a certain title, it will show with a certain value in my new co...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    6 years ago

    95Bigbluetoy -

    I started with the dataset below. Because I edited the file it reordered the columns.

    [Value] is a Calculated Column. 

     

    Adding [RateType] is just a suggestion. You can accomplish what you asked (not adding a helper column) by doing:

    Value = 
SWITCH(
    TRUE(),
    'Table'[Name] = "John Doe" && 'Table'[Title] = "Project Executive", 65,
    'Table'[Name] = "Jane Doe" && 'Table'[Title] = "Project Executive", 45,
    'Table'[Title] = "Project Executive", 50,
    25
)

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

First, use a SWITCH(TRUE()...) statement instead of nested IF statements. Far cleaner, more readable and easier to modify. Second, use the logical operators && (AND) and || (OR) to combine multiple criteria.

95Bigbluetoy's avatar
95Bigbluetoy
Helper I
6 years ago

thanks for the reply. Rather new to Power BI so trying to learn how to accomplish various tasks. I just replied to another user who suggested somewhat the same as you, but he had the same value for both John and Jane Doe. I need to have it so that John has a value of 65, Jane a value of 40 and all other PE's a value of 50. Not sure how to accomplish this with the info you provided.

 

thanks for your input.