Forum Discussion
Solved
Check column for similar values
Hi, I have a software report and on the report it has different versions on different lines eg: Microsoft Office OneDrive 21.220.1024.0005 Microsoft Office OneDrive 26.45.308.3 Its a full Software...
For your reference.
Step 1: I add a 'Software No Version' column below.
Step 2: I replaced Value,"Bit"-->"".
<After>
dommyw277 maybe add a column to return true/false
Is Duplicate =
VAR __Value = TableDup[Column1]
VAR __Rows = CALCULATE ( COUNTROWS ( TableDup ), ALL ( TableDup[Column1] ), TableDup[Column1] = __Value )
RETURN
__Rows <> 1
That doesnt work, it returns everything as false. For info the table is called Softwarescan and the column is called Software Title