Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a data set that I'm trying to evaluate, but can't figure out how to get the results that I know are there! I have a CSV data set of a listing of files in directories in different domains, as an example:
NetLogonPath | Name | Size | Domain | FullName | CreatedOn | ModifiedOn |
temp.cmd | temp.cmd | 24 | something.com | \\something.com\NETLOGON\temp.cmd | date | date |
temp.cmd | temp.cmd | 24 | test.something.com | \\test.something.com\NETLOGON\temp.cmd | date | date |
Scripts\what.bat | what.bat | 243234234 | something.com | \\something.com\NETLOGON\Scripts\what.bat | date | date |
Scripts\what.bat | what.bat | 243234234 | test.something.com | \\test.something.com\NETLOGON\Scripts\what.bat | date | date |
Scripts\what.bat | what.bat | 164000 | huh.something.com | \\huh.something.com\NETLOGON\Scripts\what.bat | date | date |
Scripts\what.bat | what.bat | 243234234 | poo.something.com | \\poo.something.com\NETLOGON\Scripts\what.bat | date | date |
What I want to see out of this data is something like:
NetLogonPath | Instances | Size | Domains |
temp.cmd | 2 | 24 | something.com, test.something.com |
Scripts\what.bat | 3 | 243234234 | something.com, test.something.com, poo.something.com |
Scripts\what.bat | 1 | 164000 | huh.something.com |
Based on above, I'd like the "NetLogonPath", size, and number of instances of each item that has the same "NetlogonPath" and "Size", and consolidating the "domain" fields into a single result.
Solved! Go to Solution.
Create the following measures in your table.
Instances = COUNTA(Table[Name])
Domains = CONCATENATEX (VALUES(Table[Domain]), Table[Domain], ", ")
Then create the table visual as follows, make sure that you choose “Don’t summarize” for Size.
Regards,
Lydia
Create the following measures in your table.
Instances = COUNTA(Table[Name])
Domains = CONCATENATEX (VALUES(Table[Domain]), Table[Domain], ", ")
Then create the table visual as follows, make sure that you choose “Don’t summarize” for Size.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |