Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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" :
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
Solved! Go to 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
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 & @SachinNandanwar Thanks a lot guys!
I used both of your suggestions and they both work 🙂
Salary Range col =
CALCULATE (
VALUES ( 'Salary sort'[Salary Range] ),
FILTER (
'Salary sort',
'Employee History'[salary] >= 'Salary sort'[Min]
&& 'Employee History'[salary] <= 'Salary sort'[Max]
)
)
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |