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>
For youre reference.
Step 0:I use these DATA below.
<DATA (2)>
Step 1: I add a column below.
Is Duplicate = IF(CALCULATE(COUNTX(FILTER('DATA (2)','DATA (2)'[Software]=MAX('DATA (2)'[Software])),'DATA (2)'[Software]),ALLEXCEPT('DATA (2)','DATA (2)'[Software]))>1,"Duplicates","Single")
Thank you but this is wrong too. Im not interested in the version number , only the Software Title so if it lists Adobe Acrobat 3 times and they are all different versions I only want the count of the software title?