Forum Discussion

Naomig2088's avatar
Naomig2088
Icon for Helper II rankHelper II
4 years ago

Dividing 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...
Need Help
Naomig2088's avatar
Naomig2088
Icon for Helper II rankHelper II
4 years ago

it would need to be divded into 4 equal parts with an even gender distribution across the hourly pay quarters. Thanks

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    Naomig2088
    Icon for Helper II rankHelper II
    4 years ago

    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's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Still not sure what you need...