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...
PaulDBrown
Community Champion
Community ChampionPlease provide sample data and a depiction of what you are trying to achieve.
Naomig2088Thanks 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.93- Naomig2088
it would need to be divded into 4 equal parts with an even gender distribution across the hourly pay quarters. Thanks
- PaulDBrown
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