Forum Discussion
Post PatronDynamic Salary Bin
Hai, I have a challenge I want to create a Salary bin based on the latest salary,
I have 2 two tabless consisting of monthly salary data and the other one is revised salary data. so I want to create a salary bin based on the latest salary. please give instructions and tips
2 Replies
- amitchandak
Super User
AlanP514 , If you want based on a column, Then you can create a new column.
Example
Switch(True() ,
[Salary] <10000, " Below 10K",
[Salary] <20000, "10K - 20K",
// Add others
)
If you need create a separate table with salary and bin
In case you need it on measure
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k 
v-zhangtiCommunity Support
Hi, AlanP514
Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
