How get a report about used space by each user

[koorosh]

Dear experts

Have a list of files and folders that each user used on the server. How can get a report that shows total space for each user on the server? For instance, the size of c:\users\koorosh represents all space used by Koorosh user.

Type	path	size
folder	C:\users\koorosh	1200
file	C:\users\koorosh\A	500
folder	C:\users\koorosh\AA	200
file	C:\users\Mike\B	10
folder	C:\users\Mike	2700
folder	C:\users\Mike\BB	800

[koorosh]

Let me try and back to you Amit. Thanks

[amitchandak · Accepted solution]

@koorosh , split by \, remove the columns that are not required. Looking at the structure , you should get user name easily

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/