Forum Discussion
Naomig2088
Helper II
Helper IIDividing data into equal quarters
Hi, I'm very new to PBI so any help would be much appreciated. I'm trying to break my data which shows hourly rate of each employee into 4 equal quarters, based on the hourly rate. The added complic...
Naomig2088Helper II
Helper IIThanks for you reply. Here is a small sample:
Id Gender Hourly Rate
1110 Female 11.1
1111 Male 24.71
1112 Female 17.31
1113 Female 8.94
1114 Male 9.63
1115 Male 9.63
1116 Female 8.43
1117 Female 9.51
1118 Female 9.63
1119 Female 8.94
1120 Male 10.49
1121 Male 13.49
1122 Female 8.94
1123 Female 9.63
1124 Female 8.94
1125 Female 17.55
1126 Male 9.43
1127 Female 14.91
1128 Female 12.35
1129 Male 9.43
1130 Female 54.48
1131 Female 15.24
1132 Female 15.93Naomig2088Helper II
Helper IIit would need to be divded into 4 equal parts with an even gender distribution across the hourly pay quarters. Thanks
PaulDBrownCommunity Champion
Thank you for providing data.
What do you mean by "4 equal parts" etc...?
It would be really helpful if you posted a depiction of the expected result
- Naomig2088
So, I would need to divide the data into 4 equal quarters based on hourly rate, lowest to highest. As an outcome, I would need a table with the number of employees in each quarter, with their hourly rate and would need for the gender to be taken into account- there are 7 males and 16 females so they would need to be distributed evenly across the hourly pay quartiles. I hope that makes sense!
- PaulDBrown
Still not sure what you need...