topic Re: Return value from another column based on conditions in DAX Commands and Tips

Return value from another column based on conditions

holywasabi — Tue, 05 Nov 2024 06:04:27 GMT

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

Re: Return value from another column based on conditions

Ankur04 — Tue, 05 Nov 2024 06:21:51 GMT

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

Re: Return value from another column based on conditions

SachinNandanwar — Tue, 05 Nov 2024 06:48:53 GMT

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

Re: Return value from another column based on conditions

holywasabi — Tue, 05 Nov 2024 07:21:16 GMT

Ankur04 & SachinNandanwar Thanks a lot guys!

I used both of your suggestions and they both work 🙂