Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I think this is a long shot but I am going to ask anyway. I have a dataset with a list of computers in our company and what software is installed on each computer. There are over 27,000 unique softwares in this dataset, but many of them are similar. For example, there are over 1,200 unique software names that contain 'ArcGIS', some of which are updates and different versions of the same software.
I there a way to automatically group softwares with a common word, such as 'ArcGIS' or 'Firefox' without me having to go through and figure out what words to group by?
Install Date | Installed On | Software Name | Software ID |
2022-06-29 | f6de9bb21bc4441052b33224cc4bcba5 | Autodesk App Manager | 252c67fc471fcd90e9d97134846d430c |
2021-11-18 | 2e4f2e881b8c1850947d41d8cd4bcb58 | ArcGIS Desktop 10.6.1 TLS Patch | 42a572721b8404108f40fc49cc4bcb72 |
2022-10-03 | 9f5c2a2587a01d90227d87b7cebb35dd | ArcGIS Desktop 10.5.1 | 2b0fb2761b00441052b33224cc4bcbfb |
2021-09-01 | f6de9bb21bc4441052b33224cc4bcba5 | Adobe Character Animator 2020 | 7ecfb79d472011d4e9d97134846d43a0 |
--
= let SoftList={"Autodesk","ArcGIS","Adobe"},fx=(t)=>List.PositionOf(SoftList,t,0,(x,y)=>Text.Contains(y,x)) in Table.Group(SampleData,"Software Name",{"tbl",each _},1,(x,y)=>Value.Compare(fx(x),fx(y)))
you can add new software name in the SoftList
Is this for a new column or a new table?
I was hoping there was a way to get it to automatically create the list of softwares so I don't have to manually search through 27,000 software instances to figure out what to group them by
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |