Forum Discussion
Check column for similar values
For your reference.
Step 1: I add a 'Software No Version' column below.
Step 2: I replaced Value,"Bit"-->"".
<After>
If all values for the software include both name and version you could use Power Query to split the column by the right-most delimiter, using space as the delimiter. That would give you a column for the name and a column for the version.
You could create a list of duplicates by creating a measure which is a simple COUNTROWS( 'Table' ), put that into a visual with the software name column and filter it so that it only shows where the value is > 1.
That doesnt work either, where i have titles like this:
Adobe Acrobat DC 26.001.21346
Adobe Acrobat DC 26.001.21346 64-Bit
Column 1 Column 2
Adobe Acrobat DC 26.001.21346
Adobe Acrobat DC 26.001.21346 64-Bit
You could try splitting it at the first numeric character, something like
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hctLCoAgEADQqwyuaxhHk7aV2/AA4aKPgpuEks6fdIH27y2LGI68BRj2K29rATsBGySSyFJpI3zzI8Dodkzlg3Oq5s6xgIsx7QHcGeyVngBcNRNKYl0rdX/coO5QUY9KeP8C", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), SplitCol = Table.SplitColumn( #"Changed Type", "Column1", Splitter.SplitTextByCharacterTransition( { "A".."Z", "a".."z", " ", "-"}, { "0".."9"}), {"Name", "Version"} ), #"Trimmed Text" = Table.TransformColumns(SplitCol,{{"Name", Text.Trim, type text}}) in #"Trimmed Text"