Group Data by Distinct Column Row

[powerbi_ex]

**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

[Cookistador]

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?

[powerbi_ex]

Do you have this PBIX?

[Cookistador · 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