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 ChampionThank 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
Naomig2088Helper II
Helper IISo, 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...