**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 |
1 ACCEPTED SOLUTION
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
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?
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
