Return value from another column based on conditions

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

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