Return value from another column based on conditions

[holywasabi]

Hi folks

I have a table called "Employee History", it has a column named "Salary".

Appreciate any help offered, much thanks!

I want to create a calculated column called "Salary Sort col" : 

• Conditions will be based on a supporting table named "Salary sort"
• Supporting table --> "Salary sort" has 3 columns : Salary Range, Min, Max
• IF(

      'Employee History'[salary] >= SELECTEDVALUE( 'Salary sort'[Min] )

      &&

      'Employee History'[salary] <=  SELECTEDVALUE( 'Salary sort'[Max] ),

      SELECTEDVALUE( 'Salary sort'[Salary Range] )

  )

Idk what I'm doing wrong but my calculated column shows nothing 😅

File link : https://drive.google.com/file/d/1fX_QSxj3OVJhG3jGk9hLuZXz5sUFESPF/view?usp=sharing

[Ankur04 · Accepted solution]

Hi @holywasabi ,

I would suggest you to create a calculated column as below to achieve the requirement.

Salary Range  = If(Salary >0 && Salary < 39999,"Below $40k",if(Salary >39999 && Salary < 59999,"$40 - $59k", and so on)

let me know if this helps.

Thanks,

Ankur

[holywasabi]

@Ankur04 & @SachinNandanwar  Thanks a lot guys!

I used both of your suggestions and they both work 🙂 

[SachinNandanwar · Accepted solution]

Salary Range col =
CALCULATE (
    VALUES ( 'Salary sort'[Salary Range] ),
    FILTER (
        'Salary sort',
        'Employee History'[salary] >= 'Salary sort'[Min]
            && 'Employee History'[salary] <= 'Salary sort'[Max]
    )
)

[Ankur04 · Accepted solution]

Hi @holywasabi ,

I would suggest you to create a calculated column as below to achieve the requirement.

Salary Range  = If(Salary >0 && Salary < 39999,"Below $40k",if(Salary >39999 && Salary < 59999,"$40 - $59k", and so on)

let me know if this helps.

Thanks,

Ankur