Forum Discussion
Helper IIIgrouping data for custom category
Hi ALL, i have data of an emp login who works for multiple clients , employee logs hours he worked for each client he worked for and i have summaried the total hours employee worked on a day in a column "Hours per day" , Now i want to bin the data like the second table , 0-7 hours as one bin , 7-9 hours as one bin , above 9 hours as one bin , can someone please help
| Emp | client | Date | hours | Hourrs per day |
| 1 | A | 5/15/2020 | 1 | 3.5 |
| 1 | B | 5/15/2020 | 1.5 | 3.5 |
| 1 | C | 5/15/2020 | 1 | 3.5 |
| 1 | D | 5/16/2020 | 4 | 10 |
| 1 | E | 5/16/2020 | 6 | 10 |
| 2 | A | 5/15/2020 | 6 | 11 |
| 2 | B | 5/15/2020 | 2 | 11 |
| 2 | C | 5/15/2020 | 3 | 11 |
| 2 | D | 5/16/2020 | 1 | 9 |
| 2 | E | 5/16/2020 | 8 | 9 |
| Emp1 | 0 to 7 | 7 to 9 | Above 9 |
| 1 | 1 | 0 | 1 |
| 2 | 0 | 1 | 1 |
@v-chuncz-msft @amitchandak @v-wxu@mgwena @cham @cham @amitchandak @Greg_Deckler @Mariusz @Mariusz @yij @yij v-yingj@ v-diye-msft@v-x @v-eachen-msft @v-lionel-msft @v-juanli-msft @v-jayw-msf @v-kelly-msft@v-zhenbw-msft v-yingj@ @harshnathani
Hi Truelearner ，
You could try below measure and refer to my sample for details.
Measure 2 = COUNTX(SUMMARIZE('Table (2)','Table (2)'[Emp],'Table (2)'[Date],'Table (2)'[status]),'Table (2)'[status])+0Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- parry2k
Super User
Truelearner add a new column for the bin
Bin = SWITCH ( TRUE(), Table[Columns] > 9, "More than 9 hours" Table[Columns] > 7, "7 - 9", "0-7" )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Truelearnerif i create a column that column will reference the total hours in a day and the count associated with the duplicated depending on the number of line items that employee have on that day .
daxCommunity Support
Hi Truelearner ,
You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Truelearner
can someone from community support take a look at it please
- parry2k
Truelearner can you share pbix file with sample data and expected output and I will look at it. My solution answered the original question you posted but seems like there is more than that.
