Forum Discussion
Group Data by Distinct Column Row
**I pasted sample data below**
How to change this table data where it groups the each Business Unit by Type and sorted TimeLogged like the Final Output in Power BI? I am not sure whether to accomplish this as a dax virtual table or in power query.
| Business Unit | Type | TimeLogged |
| Mcdonalds | Client | 12:01:00 AM |
| Mcdonalds | Staff | 12:01:00 AM |
| Mcdonalds | Reviewer | 12:01:00 AM |
| AppleBees | Client | 12:02:00 AM |
| AppleBees | Staff | 12:02:00 AM |
| AppleBees | Reviewer | 12:02:00 AM |
| Ruby Tuesday's | Client | 12:03:00 AM |
| Ruby Tuesday's | Client | 12:03:00 AM |
| Ruby Tuesday's | Staff | 12:03:00 AM |
| Ruby Tuesday's | Staff | 12:03:00 AM |
| Ruby Tuesday's | Reviewer | 12:03:00 AM |
| Nacho's | Client | 12:04:00 AM |
| MTS Foods | Client | 12:04:00 AM |
| MTS Foods | Staff | 12:04:00 AM |
| MTS Foods | Reviewer | 12:04:00 AM |
Please find the PBI on the page called Group Data
https://drive.google.com/file/d/1ALLBwOtcJrxUc1NO7KVNj7ZjhXI_Rnwp/view?usp=sharing
If you have more questions, do hesitate to post them
If I answer to your question, please accept this answer as a solution
3 Replies
- Cookistador
Super User
What are you trying to achieve?
A matrix would be enough
Add the fields in Rows
If it is not what you are trying to achieve, can you give more context?
Do you have this PBIX?
- Cookistador
Please find the PBI on the page called Group Data
https://drive.google.com/file/d/1ALLBwOtcJrxUc1NO7KVNj7ZjhXI_Rnwp/view?usp=sharing
If you have more questions, do hesitate to post them
If I answer to your question, please accept this answer as a solution
